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
Duplicate Values in Another Output
Thanks & Regards
Siva
No comments:
Post a Comment