DSXchange

Hi All,

Can anyone please tell me what is the diff. between change capture and difference stage?

Which stage i should prefer?? i m very new to this tool

Thanks in advance.

Regards,
Nihar

Hi ,
Change Capture is used to track the old and new values in the slowly changing dimension table.If there is huge amount of data then we use
Change Capture Stage.
Difference is also used for the same purpose but for small amount of data.
it checks Column by Column.

Always try to use ChangeCapture Stage.

thanx reddy

The outputs are different also. And the Compare stage gives yet another variant.