target1 SQ->Router-> target2 1.In router

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

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

Answer Posted / ramesh

target1
SQ->Router->
target2

1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.

Thanks & Regards
Ramesh

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is Session and Batches?

1084

What do you mean by filter transformation?

938

Parameter and variable differences

2048

Explain direct and indirect flat file loading (source file type) - informatica

1303

Global and Local shortcuts. Advantages.

2016

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2037

COM components can be used in Informatica

2366

Why update strategy and union transformations are active?

1027

What is aggregator transformation in informatica?

924

What is exclusive and normal mode for repository services?

1122

Explain the use of aggregator cache file?

1233

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1983

What is pmcmd command?

1086

What is an active transformation?

1076

draw informatica architecture 8.6 ?

3860