i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.
Answer Posted / nish
remove duplicate-> retail last
Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the functionalities of link collector?
What is the difference between the local container and shared container?
What are the types of jobs we have in datastage?
how to sort two columns in single job in datastage.
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How you Implemented SCD Type 1 & Type 2 in your project?
What is job control?
Demonstrate experience in maintaining quality process standards?
What are iconv and oconv?
What are the steps required to kill the job in Datastage?
How will you move hashed file from one location to another location?
What is size of a transaction and an array means in a datastage?
What are the various kinds of containers available in datastage?
What is the importance of the exception activity in datastage?
How complex jobs are implemented in datstage to improve performance?