diff. between change capture and difference stage

niharranjan · Post by **niharranjan** » Thu Jan 31, 2008 3:53 am

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

gnreddy · Post by **gnreddy** » Thu Jan 31, 2008 5:50 am

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.

niharranjan · Post by **niharranjan** » Thu Jan 31, 2008 5:57 am

thanx reddy

ray.wurlod · Post by **ray.wurlod** » Thu Jan 31, 2008 7:43 am

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

DSXchange

diff. between change capture and difference stage

diff. between change capture and difference stage

Re: diff. between change capture and difference stage