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
- 8304 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
How many areas for files does datastage have?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the important features of datastage?
How to read multiple files using a single datastage job if files have the same metadata?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to implement complex jobs in data stage?
Define Routines and their types?
CHANGE CAPTURE
what is the difference between == and eq in UNIX shell scripting?
Describe the main features of datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the differentiate between data file and descriptor file?
what is the use of surogate key in datastage
How do you schedule or monitoring the job?
What are the partitioning techniques available in link partitioner?
