Dear Srini,
The same issue is coming in one of my job.
but the issue get resolved by using delete then insert rather update then insert.
I have no clue why it is happening.
Please reply.
Regards,
Sany
SCD Type 2 in Datastage
Moderators: chulett, rschirm, roy
SCD Type 2 in Datastage
Aspirant
You replied to a five year old post, this one to be precise. Let's get you into one of your own.
What exactly is this "same issue" that you are having? Do you understand the difference between the two actions you posted: "delete then insert" versus "update then insert"?
What exactly is this "same issue" that you are having? Do you understand the difference between the two actions you posted: "delete then insert" versus "update then insert"?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers