Output links from Change Capture

getsatish_gk · Post by **getsatish_gk** » 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)

ray.wurlod · Post by **ray.wurlod** » Wed Jan 19, 2011 3:18 pm

How many times do you propose to ask this question?

getsatish_gk · Post by **getsatish_gk** » Thu Jan 20, 2011 12:36 am

ray.wurlod wrote:How many times do you propose to ask this question? ...

:D one time asking. Browsed through the forum on change captures... didn't find the proper answer

Let me know if you have any suggestions or didn't understand the question?