Sequential file stage -> sort stage -> filter stage -> 2 datasets
read the data into sequential file in sort stage make create key change column = True its adds one more column called Key_Change this column identifies duplicates and unique records for duplicate its assign 0 unique 1 based on sort key
filter stage take where keychange= 1 for unique where Keychange= 0 for duplicate records
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!