capture the changes in the fields!!
Posted: Thu Aug 11, 2011 11:05 am
There are 10 fields from the source which have a key column and updated date.
Lets say the key column is 123 which has 4 records with some changes in the fields and updatedate.
Using sort stage the records are sorted with the key column and update date.
Now used an other sort stage to generate the key column for the changes in the fields.
The next step is we have to compare the previous and next record for the same keycolumn(123) for 4 records and if any change in the record for all the fields except the date forward it or else ignore it.
Is there any function in the transformer or using a stage variable ?
Please suggest me
Thanks
Lets say the key column is 123 which has 4 records with some changes in the fields and updatedate.
Using sort stage the records are sorted with the key column and update date.
Now used an other sort stage to generate the key column for the changes in the fields.
The next step is we have to compare the previous and next record for the same keycolumn(123) for 4 records and if any change in the record for all the fields except the date forward it or else ignore it.
Is there any function in the transformer or using a stage variable ?
Please suggest me
Thanks