i have a scenario like two columns(Empno, Ename) in that duplicate records are t

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.

Question Posted / prasad

4 Answers
6708 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question..

Answer / 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

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question..

Answer / 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

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question..

Answer / narasimha rao k

By using Removeduplcate stage in datstage

This stage having avalabel Removeduplicate 1st and last you select last automatically apply to second duplicate data

Is This Answer Correct ?

6 Yes

6 No

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question..

Answer / nish

remove duplicate-> retail last

Alternate MEthod: if there are only two occurences then sort stage-> descending-> remove duplicates

Is This Answer Correct ?

0 Yes

0 No

Post New Answer