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
- 8294 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / pavani
if we have n duplicates
source---->transformer-------->target.
in transformer we define 2 stage variables
if empno=stg_var2 then stg_var1+1 else 1------->stg_var1;
emp_no-------->stg_var2;
now the constraint for target is stg_var1=2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the components of datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
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
what are the devoleper roles in real time? plz tell i am new to datastage....
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between orabulk and bcp stages?
how to export or import the jobs in .ISX file
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How complex jobs are implemented in datstage to improve performance?
What is the purpose of pivot stage and types of containers in datastage
Define Merge?
How to read multiple files using a single datastage job if files have the same metadata?
table actions available in oracle connector?
What is usage analysis in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
