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
- 24216 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
Can you explain how could anyone drop the index before loading the data in target in datastage?
Describe the main features of datastage?
How to perform incremental load in datastage?
Differentiate between datastage and informatica?
What are datastage sequences?
What are some different alternative commands associated with "dsjob"?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define Routines and their types?
What are the types of containers in datastage?
what is the use of materialized view?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the job parameters?
What are the main features of datastage?
Can you define merge?
State the difference between an operational datastage and a data warehouse?
