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 / 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
To see hidden files in LINIX?
What is meta stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Which algorithm you used for your hashfile?
What is the difference between datastage and informatica?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the project in datastage?
What are orabulk and bcp stages?
What is merge stage?
How to clean the datastage repository?
How many types of sorting methods are available in datastage?
What are the different type of jobs in datastage?
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?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?