DataStages_Real_Time _Scenarios_ with Screen Shots_and _Solution

Sunday, June 1, 2014

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?


i have a source table with distinct and duplicate rows of data. i want to load the data in target like one target to be only distinct rows of data and other target to be only duplicate rows of data

 Pass the data to Aggregator and count the number of records for the Key Combination. Collect the Key and Count into a intermediate file


. Read the Intermediate file and filter the records which are having Count<=1, then join with the master input file based on the keys



                                          Now yu can see in out put Unique values in one output

Duplicate Values in Another Output 




Thanks & Regards
Siva

No comments:

Post a Comment