Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 24537 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / dilip anand k
Its Simple!!
All you have to do is link your source to a Sort Stage.
Sort the data and generate a Key Change column.
Key Change column = ‘1’ represents that the record is
unique while Key Change Column = ‘0’ represents the
duplicates.
Put a Filter stage and filter out the data into two
different outputs based on the generated Key Change Column.
| Is This Answer Correct ? | 21 Yes | 5 No |
Post New Answer View All Answers
What is the use of hoursfromtime() function in transformer stage in datastage?
What is a merge in datastage?
What is the importance of the exception activity in datastage?
What could be a data source system?
What is the difference between odbc and drs stage?
Differentiate between hash file and sequential file?
how do u catch bad rows from OCI stage? And what CLI stands for?
Can you explain link buffering?
What is a datastage job?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Define Job control?
What are system variables and sequencers in datastage
Differentiate between operational datastage (ods) and data warehouse?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Explain the importance of surrogate key in data warehousing?
