Datastage Scenario?

A_SUSHMA · Post by **A_SUSHMA** » Mon Jan 20, 2014 9:55 am

Hi All,

I have one scenario. Could you please Help me the below scenario.

INPUT IS

EMPNO,ENAME
100,SUSHMA
100,HARITHA
101,SUSHMA
101,SUSHMA
102,HARITHA
103,PUJA
103,PUJA
104,SUSHMA
104,HARITHA

I WANT OUTPUT AS

EMPNO,ENAME
100,HARITHA
101,SUSHMA
101,SUSHMA
102,HARITHA
103,PUJA
103,PUJA
104,HARITHA

In the above example where extract the ENAME group contains the name as HARITHA remaining records will be discard.

Thanks in Advance your Help...

soumya5891 · Post by **soumya5891** » Mon Jan 20, 2014 1:57 pm

What is the DS version you are using?

chulett · Post by **chulett** » Mon Jan 20, 2014 4:38 pm

And what have you tried so far? What issues did you have when you tried them?

ray.wurlod · Post by **ray.wurlod** » Mon Jan 20, 2014 7:06 pm

Why is 101,SUSHMA preserved, rather than 104,SUSHMA ?
What exactly are your transformation rules?

A_SUSHMA · Post by **A_SUSHMA** » Mon Jan 20, 2014 11:40 pm

Hi Ray,

In the above example I want to check EMPNO and ENAME.IF EMPNO is same and ENAME is 'SUSHMA' and 'HARITHA' Then only I want output EMPNO,ENAME is HARITHA and Remaining all are same.

RPhani · Post by **RPhani** » Tue Jan 21, 2014 3:53 am

Hi Sushma,

The below procedure will help for your Scenario.

1)EMPNo of HARITHA(100,102,104) are reference to a LookUp.
2)It's O/P has 5 recs and Rej has 4 recs(101,103).
3)Take a Transformer constaint ENAME='HARITHA' on LookUp O/P.
4)Funnel with LookUp Rejects

Thanks in advance for alternate ideas.
---------------------------------------
RPhani