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 / 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
What are the different options associated with dsjob command?
What is the difference between odbc and drs stage?
What is job control?
how can we create rank using datastage?what is the meaning of rank?
What are stage variables, derivations and constants?
How complex jobs are implemented in datstage to improve performance?
Define meta stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Which warehouse using in your datawarehouse
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
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Define ds designer?
What is the sortmerge collector?
how to write server Routine coding?
client know skid info?