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 / narasimha rao k
By using Removeduplcate stage in datstage
This stage having avalabel Removeduplicate 1st and last you select last automatically apply to second duplicate data
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What is data partitioning?
What is a merge?
Why do we use exception activity in Datastage?
What are the types of views in datastage director?
What is process model?
What are the benefits of datastage?
Define Routines and their types?
Explain connectivity between datastage with datasources?
How the ipc stage work?
How do you import and export the datastage jobs?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
EXPLAIN SCD
What is difference between join, merge and lookup stage?
How we can covert server job to a parallel job?
What are the different types of lookups in datastage?