SQ-->EXP-->ROUTER-->TRg EMPID IN_EMPID in exp t/r create varia

hi all hi have flat file like below my requirement is
empid,ename,sal,loc
101,vamshi,5000,hyd
101,vamshi,5020,hyd
201,raju,5000,hyd
202,ram,4000,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
i want the o/p like this
in one target
201,raju,5000,hyd
202,ram,4000,hyd
and in second target
101,vamshi,5000,hyd
101,vamshi,5020,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd

Question Posted / sivakumar

9 Answers
11038 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / sivakumar

SQ-->EXP-->ROUTER-->TRg
EMPID
IN_EMPID
in exp t/r
create variable port v_flag in that write the following condition
IIF(EMPID = IN_EMPID ,'1','0')

in router develop 2 conditions for v_flag
the values in the true will b directed to one output which we get the duplicated values

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a standalone command task?

1256

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

What is the procedure for creating independent data marts from informatica 7.1?

1120

Explain Dataware house architecture .how data flow from intial to end?

2650

Can we create multiple integration service on single repository?

1242

What is the Rank index port in Rank transformation?

1102

Explain the tuning lookup transformation - informatica

1047

What is the function of union transformation?

1204

What is status code in informatica?

1065

what is unit testing?tell me proceedure

2276

Define filter transformation?

1149

How can you define user defied event?

1076

Can you use flat files in Mapplets.

2715

What is the way to execute pl/sql script using informatica mapping?

1681

Write the different tools in the workflow manager?

1119