Upsert Strategy- Order of Execution
Posted: Wed Feb 16, 2005 1:48 am
Upsert Strategy- Order of Execution
Hi
I have implemented the UPSERT strategy for the Dimension load. Iam using a oracle sequence as the surrogate key. In the Target stage i have specified seq.nextval for the surrogate key
First Run: Source Records =3
Oracle Sequence ( surrogate key)
1
2
3
Second Run : No change in the source record
Oracle Sequence ( surrogate key)
1
2
3
ThirdRun : Source records = 4( 3 old + 1 new record)
Oracle Sequence ( surrogate key)
1
2
3
7 - New record
Please let me know why this is happening , since in the second run only update is happening for the exising record why the sequence is getting incremented.
What is the order of execution of Upsert strategy ( Update and Insert / Insert and Update)
Thanks in advance
Maharaj
Hi
I have implemented the UPSERT strategy for the Dimension load. Iam using a oracle sequence as the surrogate key. In the Target stage i have specified seq.nextval for the surrogate key
First Run: Source Records =3
Oracle Sequence ( surrogate key)
1
2
3
Second Run : No change in the source record
Oracle Sequence ( surrogate key)
1
2
3
ThirdRun : Source records = 4( 3 old + 1 new record)
Oracle Sequence ( surrogate key)
1
2
3
7 - New record
Please let me know why this is happening , since in the second run only update is happening for the exising record why the sequence is getting incremented.
What is the order of execution of Upsert strategy ( Update and Insert / Insert and Update)
Thanks in advance
Maharaj