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
- 8074 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 do you run datastage job from the command line?
Lookup constraints
Differentiate between odbc and drs stage?
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?
Triggers,VIEW,Procedures
What is ibm datastage flow designer?
What are the types of views in datastage director?
Can you explain link buffering?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
what is the difference between == and eq in UNIX shell scripting?
What are the main features of datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
Explain the situation where you have applied SCD in your project?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are constraints and derivations?
