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
- 8290 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
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
How a server job can be converted to a parallel job?
how to delete one row in target dataset
Define Routines and their types?
What is a merge?
What is meta stage?
What are routines in datastage?
What are orabulk and bcp stages?
How to clean the datastage repository?
What is the difference between orabulk and bcp stages?
What is the difference between passive stage and active stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
how many rows sorted in sort stage by default in server jobs
What are the benefits of datastage?
Why do we use exception activity in Datastage?
