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
How to convert RGB Value to Hexadecimal values in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is the difference between server job and parallel jobs?
Define ds designer?
What is apt_config in datastage?
How can one find bugs in job sequence?
What is the difference between datastage and informatica?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the different types of lookups in datastage?
Why do we use exception activity in Datastage?
What are the types of containers and how to create them?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How can we improve performance of data stage jobs?
Differentiate between data file and descriptor file?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?