Output links from Change Capture
Posted: Wed Jan 19, 2011 5:21 am
Hi All, :D
I have a sinario in which I have to compare the after dataset with before dataset and wants the output in the following manner
1) If change code=1 or 3 (ie., record is new or update) then select the columns from after dataset
and
2) if change code=0 (ie., record is same) then i want to get the columns from before dataset.
1) case can be easily established in the transfermer but for 2) I am not able to get the columns from Before Dataset.
Let me know if change capture stage only give the output from after dataset link? If yes, what could be ways to achieve the case 2)
I have a sinario in which I have to compare the after dataset with before dataset and wants the output in the following manner
1) If change code=1 or 3 (ie., record is new or update) then select the columns from after dataset
and
2) if change code=0 (ie., record is same) then i want to get the columns from before dataset.
1) case can be easily established in the transfermer but for 2) I am not able to get the columns from Before Dataset.
Let me know if change capture stage only give the output from after dataset link? If yes, what could be ways to achieve the case 2)