Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8092 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / reddy
Source File/Table--->Transformer-->Target
Transformer stage:
---------------------------
Take two stage variables
sv-->Empno or Ename (drag and drop column(s))
sv1-->if Empno=sv or Ename=sv Then sv1+1 Else 1
in constraint --> sv1=2
u will get second duplicate record
Plz correct me if i am wrong...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Difference between sequential file and data set?
root tree will find which is server job and which is parallel job?
How to find value from a column in a dataset?
What is merge stage?
what is the difference between == and eq in UNIX shell scripting?
What is the process of killing a job in datastage?
what is the use of surogate key in datastage
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the different types of lookups in datastage?
What is a merge?
What are system variables and sequencers in datastage
what is flow of project?
What are the various kinds of containers available in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
what are the errors,warnings in datastage
