| |
GeekInterview.com > Tech FAQs > DataStage
| Print | |
Question: How do you remove duplicate records from a file and capture the rejected records in a separate file.
|
| May 05, 2008 10:28:17 |
#5 |
| nagoosk |
Database Expert Member Since: November 2007 Total Comments: 13 |
RE: How do you remove duplicate records from a file and capture the rejected records in a separate file.
|
| sort the records using the key field.In sort stage put "key change column = true".Then zero will be assigned to the duplicate records.then put a condition as which is record is zero then send it to reject link |
| |
Back To Question | |
