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
Which commands are used to import and export the datastage jobs?
how to export or import the jobs in .ISX file
How many types of hash files are there?
what is ds administrator used for?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Explain entity, attribute and relationship in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are the types of hashed files in data stage
What are constraints and derivations?
How a source file is populated?
What is process model?
What is the different type of jobs in datastage?
What is datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
On which interface you will be working as a developer?