Compare the rows in data stage?

[fareeda_b]

HI ,

How to compare the rows in data stage?


thanks in advance
fareeda

[ray.wurlod]

A field at a time.

[Hemant_Kulkarni]

change capture would help

[ray.wurlod]

I ignored that because the post was made in the server forum.

[madhavi83]

HI ,

How to compare the rows in data stage?


thanks in advance
fareeda

hi 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)

[ray.wurlod]

Welcome aboard. Please maintain a professional standard of written English here on DSXchange. This will help those whose first language is not English.

[bkarth]

HI ,

How to compare the rows in data stage?


thanks in advance
fareeda

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).

If you use 8.1 It includes this stage.

I hope it is helpful.

Thanks,
KB

[ray.wurlod]

RowSplitter and RowMerger stages are available at least back to version 7.5, maybe even to 7.0.