Requirement:
A. Insert of all New records to DataWarehouse
B. Update DW when changes are made to specific columns ONLY.
Any thoughts or comments?
![Smile :)](./images/smilies/icon_smile.gif)
Step 1. Obtain seq file containing TODAY transactions.
Step 2.
Job1: DBMS lookup to determine INSERTS (key not found)
Source Link= Today.seq
Ref Link = DW
<<LookupStage>>
Output Link1 [NOT.FOUND]= Inserts.ds
Output Link2 [FOUND]= CouldBeUpdate.ds
Output Link3 [FOUND]= FoundInDw.ds
Job2: Compare-Determine which rows have a change to the required columns
Source Link1= CouldBeUpdate.ds
Source Link2= FoundInDw.ds
<<CompareStage>>
Output Link =CompareResults.ds
Job3: Seperate updates from no change rows
Source Link1= CompareResults.ds
<<SwitchStage>>
Output Link1 [Result Code<>0] = Updates.ds
Output Link2 [rej] = NoChange.ds
Step 3.
Do Inserts and Updates to the DW
Inserts.ds
Updates.ds