on 2023 Dec 28 7:38 AM
Hi
For my actual data I use 2 ETLs for to different measure (unfortunately - dur to technical reasons I'm not able to use one ETL with 2 measures)
I want to use the "Clean and replace subset of data" method -
However as measures do no exist in it - the second ETL running, always deletes the first one
How can I solve that? any workaround?
or when will measure be added to the method?
thank you
Request clarification before answering.
dd5
dd5Measure would be taken from the mapping section. I do not think the second ETL should delete the first measure. ETL1 populates Measure 1 and ETL2 populates Measure 2. Clean and Replace for ETL1 should only delete Measure 1 with the dimension combination specified for clean and replace and ETL2 should only clean Measure 2 and replace Measure 2.
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi N1kh1l,
I have tested this scenario multiple times and it seems that 'clean and replace subset of data' will wipe out the entire facts table within the specified scope of dimensions, irrespective of the ETL mapping of the measures in the import settings.
I.e. Import model consisting of {Dim1, Dim2, Dim3, Dim4} and {Measure1, Measure2, Measure3}
ETL 1 (clean and replace subset of data) - where measures are mapped only for Measure1 and Measure2
ETL 2 (clean and replace subset of data) - where measures are mapped only for Measure3
On both runs, it will wipe out all measures and replace, so the end state after ETL2 is Measure1 and 2 will be dropped.
Do you know if there is a workaround to clean and replace subset ONLY for specific measures?
Regards,
Benji
User | Count |
---|---|
45 | |
9 | |
9 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.