HI ,
How to compare the rows in data stage?
thanks in advance
fareeda
Compare the rows in data stage?
Moderators: chulett, rschirm, roy
Compare the rows in data stage?
Last edited by fareeda_b on Wed Sep 10, 2008 3:18 am, edited 1 time in total.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Compare the rows in data stage?
hi fareeda,fareeda_b wrote:HI ,
How to compare the rows in data stage?
thanks in advance
fareeda
ans for your que is (maintain a key column in the change capture stage,based on the key column it will compare before dataset& after dataset.and also if you change any values in after dataset maintain the change values based on this also it will compare before dataset and after dataset and generate the changecodes)
Thanks,
Madhavi
Madhavi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Compare the rows in data stage?
Server jobs have a CRC32() function that you can use to determine if any part of a row has changed. Comparing the new CRC32() result with the previous CRC32() result. I have seen this done two ways. One is to populate the CRC column by using CRC32(col1:col2:col3:...etc) for all columns. Another is to use the CRC32() on the result of the RowMerger stage (There is also a RowSplitter stage).fareeda_b wrote:HI ,
How to compare the rows in data stage?
thanks in advance
fareeda
If you use 8.1 It includes this stage.
I hope it is helpful.
Thanks,
KB
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: