DSXchange

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?

From where do the two inputs come?

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.

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?

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

- Pavan