I have a scripted source (e.g. fact_update) that will update the fact table (e.g. fact_table) with multiple column keys and dates (analysed by date).
I only need to update the measure deleted_flag to 1 (for some records) and then another scripted spurce (e.g. delete_record) to execute the DELETE FROM.
Given that these records will be deleted eventually, I do not need to reassign other measures like [measure_a] = [Grain(fact_table).measure_a] in the fact_update scripted source.
I am aware that I need to reassign the column level keys in fact_update scripted source:
[col1_LK] = [Grain(fact_table).Sum: col1_LK]
[col2_LK] =[Grain(fact_table).# col2_LK]
[col3_LK] =[Grain(fact_table).# col3_LK]
Do I need to reassign the columns marked as Analysed by Date? And mark them as "Analysed by Date" in relate of fact_update scripted source? Or level keys will suffice to update the deleted_flag = 1?
