Step 1: Drag the source to mapping and connect it to an aggregator transformation.Step 2: In aggregator transformation, group by the key column and add a new port call it count_rec to count the key column.Step 3: connect a router to the aggregator from the previous step.In router make two groups one named "original" and another as "duplicate"
In original write count_rec=1 and in duplicate write count_rec>1.The picture below depicting group name and the filter conditionsStep 4: Connect two group to corresponding target table.
Thursday, April 3, 2014
Separating duplicate and non-duplicate rows to separate tables
Subscribe to:
Post Comments (Atom)
BEST PYSPARK LEARNING SITES https://www.youtube.com/watch?v=s3B8HXLlLTM&list=PL2IsFZBGM_IHCl9zhRVC1EXTomkEp_1zm&index=5 https://www...
-
UNIX shell script Interview Questions How to calculate number of passed arguments ? $# How to get script name inside a script ? $0...
-
Performance improvement Tips using Hint in OBIEE 11g RPD or Other ways.. We can improve the performance of reports by doing tuning using ...
-
OBIEE12c Creating Analyses and Dashboards Oracle BI is a comprehensive collection of enterprise business intelligence functionality t...
Hi there to every one, since I am genuinely keen of
ReplyDeletereading this website's post to be updated daily. It carries
nice data.
kajal agarwal hot