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
10504 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

Which are the different editions of informatica powercenter that are available?

972

What is the session task and command task?

995

What do you mean by blocking transformation?

972

What is the difference between stop and abort in informatica

1045

What are the new features of informatica 9.x in developer level?

941

Implementation methodology

1657

what are factless facts? And in which scenario will you use such kinds of fact tables.

1744

What is rank transformation in informatica

1113

What is a filter transformation and why it is an active one?

909

What are the features of complex mapping?

1100

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1928

design of staging area?

1966

Briefly define a session task?

1057

how to load rows into fact table in data warehouse

1118

What is the function of look up transformation?

1058