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
diff. between change capture and difference stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore
Re: diff. between change capture and difference stage
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.
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.
gangula.narayan reddy
-
- Participant
- Posts: 18
- Joined: Mon Jul 23, 2007 1:32 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: