Change capture issue

divine · Post by **divine** » Sun Aug 05, 2007 6:18 am

Hi,
Whenever I try capturing an already updated record using the change capture stage,it shows the same record with a change code=2 though
ideally it should show 0 records.I may be missing with some options in the change capture stage.Can anybody help me with it?

ray.wurlod · Post by **ray.wurlod** » Sun Aug 05, 2007 2:34 pm

From where do the two inputs come?

divine · Post by **divine** » Sun Aug 05, 2007 11:40 pm

ray.wurlod wrote:From where do the two inputs come?

The two input are coming from two datasets created from two tables in an earlier job that runs before it.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 06, 2007 1:51 am

Are you using the default codes for the change type? Or are you setting your own specific codes? Have you inspected the result, to see whether what is being reported is being reported correctly?

pbatchu · Post by **pbatchu** » Thu Aug 09, 2007 4:53 pm

Hi Divine,
Are the inputs are sorted and partitioned on the same keys?

- Pavan