Dear all,
I would like to ask you for help.
I’ve creeated imcremental loading of my fact table based on two-steps instruction:
https://bodataservices.blogspot.com/search?q=Improving+Performance+-+Part+5
So first step I’ve created just comparision table as rows from exisiting (than target) table which exist in new loaded tble (than source table). And Second step I used table comparision with source table with new and updated fields, comparision table from previous step and target table.
Unfortunately records are being added but not updated.
I found out information that source table must be imported one (Is it true?) - but it didn’t help.
Has anyone of you any idea what can be the reason? Are there any other rules and conditions for this transform?
I have couple questions:
- Does (and which) source, target and comparision tables have to have the same columns and columns order?
- Is it true that if I dodn’t put any compare columns it is taking all columns from comparision table
I will be gratefull for your help.
Joanna
joannaid (BOB member since 2019-01-18)