Problem with Change Capture stage

arnie_nits · Post by **arnie_nits** » Sun Mar 23, 2008 10:40 pm

Hi,

I want to find whether 2 file are matching or not. I have used the change capture stage. Before that I have put sorter to sort the data. But no record is passing after the change capture stage.

Warning:
Change_Capture_284: When checking operator: User inserted sort "Sort_275" does not fulfill the sort requirements of the downstream operator "Change_Capture_284"

Please help.

Regards
Arnie

chulett · Post by **chulett** » Sun Mar 23, 2008 11:33 pm

Search the forums for "does not fulfill the sort requirements of the downstream operator".

chvenkat.v · Post by **chvenkat.v** » Sun Mar 23, 2008 11:38 pm

Hi Arnie,

In change capture stage, Change Keys must be same order in properties and input partitioning order also same for both the input links. and we the CCS, one property is their drop output for copy is true/false.

i think in ur job it is true. bcuz of that no record is passing after the change capture stage.

Regards
venkat

chvenkat.v · Post by **chvenkat.v** » Sun Mar 23, 2008 11:41 pm

Hi Arnie,

In change capture stage, Change Keys must be same order in properties and input partitioning order also same for both the input links. and we the CCS, one property is their drop output for copy is true/false.

i think in ur job it is true. bcuz of that no record is passing after the change capture stage.

Regards
venkat

ray.wurlod · Post by **ray.wurlod** » Sun Mar 23, 2008 11:42 pm

Would you like to re-express that last sentence in English please?

Not everyone on DSXchange is familiar enough with English for what you wrote to make sense. Let's make it as easy as possible for them by sustaining a standard of professional written English.

arnie_nits · Post by **arnie_nits** » Mon Mar 24, 2008 4:13 am

Still having a problem. The total records from both the links(before and after) gets added up in the change capture stage. What may be the reason for that???

Thanks
Arnie