Using the Change Capture stage

ag_ram · Post by **ag_ram** » Tue Apr 03, 2007 4:11 am

Hello Folks

I have a requirement to merge 2 files , with precedence to the first file.
I have used a change capture to do this .
File1 is copied and one is put to output and other link is put to change capture, file2 is directly put to change capture . After ChangeCapture data is merged with file1 data and duplicate is removed . Although looks logically ok , iam not getting expected output !
need your expertise on it ..

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 6:53 am

What are you expecting to get? What do you believe is happening that is not documented behaviour? Others find that the stage works as documented.

vmcburney · Post by **vmcburney** » Tue Apr 03, 2007 5:35 pm

To merge the two files you would need to run Change Capture AND Change Apply. Otherwise you would only end up with output from the primary file and nothing from the lookup file. You might be better off with the Merge stage that runs updates from the lookup file against the primary file in one step.

csrazdan · Post by **csrazdan** » Tue Apr 03, 2007 8:53 pm

Check Link ordering on CDC stage. Ensure you have correct before and after link. This is one common mistake in CDC stage...
Hope it helps......

ag_ram · Post by **ag_ram** » Fri Apr 06, 2007 4:30 am

Thanks for your replies

The following was the mistake i had made

The inputs were hash partitioned and sorted , and i was giving the partition to be Auto in the stage

Thanks to you too Vincent , i need data from only one file where keys were same so the "after" link was that , if uniques were present in both they will come out as inserts/deletes from CC stage , so i need not have a change apply in conjunction .

Thanks again , marking this resolved...