Page 1 of 1

Problem with Change Capture stage

Posted: Sun Mar 23, 2008 10:40 pm
by arnie_nits
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

Posted: Sun Mar 23, 2008 11:33 pm
by chulett
Search the forums for "does not fulfill the sort requirements of the downstream operator".

Posted: Sun Mar 23, 2008 11:38 pm
by chvenkat.v
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

Posted: Sun Mar 23, 2008 11:41 pm
by chvenkat.v
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

Posted: Sun Mar 23, 2008 11:42 pm
by ray.wurlod
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.

Posted: Mon Mar 24, 2008 4:13 am
by arnie_nits
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