i have data like sam ram sam raj ram I want two targets trgt1 ram sam

i have data like
sam
ram
sam
raj
ram

I want two targets
trgt1
ram
sam

trgt2

raj
how can i do this in datastage?

Question Posted / winkle

4 Answers
8042 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj ho..

src.....>agg........>t/r..........2trgs
take src as seqfiles and take aggregater stage is for
calculate count of records based on name coloumn,next take
the transformer is for apply constraints like cnt=1 then go
for trg1

Is This Answer Correct ?

7 Yes

0 No

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj ho..

Answer / subhash

1) If SRC is either Oracle or Seq File

SRC--->AGG---->fILTER---->TGT1
...................|
...................|
..................TGT2

the main data is:
sam
ram
sam
raj
ram
from aggregator stage, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

2) If SRC is DataBase,

Orcl Conector----->Filter---->TGT1
.......................|
.......................|
......................TGT2

SELECT NAME, COUNT(NAME)
FROM EABLE_NAME
GROUP BY (NAME)
from the Above Query, the output is:
sam,2
ram,2
raj,1

Then specify the count<>1 in the Filter for TGT1 then you get:
ram
sam

in another link for TGT2, give count=1. THEN YOU GET:
raj

Is This Answer Correct ?

6 Yes

1 No

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj ho..

Answer / reddymkl.dwh

Small correction Ramu, Instead of Transformer stage use Filter stage it will give performance gain.

Is This Answer Correct ?

0 Yes

0 No

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj ho..

Answer / cva

take seqfile for loading src then take filter stage and take
two outputs from filter . write condition in filter stage
use where clause=col like 'sam' and col like 'ram' for one
trg and for second also like that.

Is This Answer Correct ?

1 Yes

6 No

Post New Answer