please give the clear picture of this logic

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

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

Answer Posted / dj

please give the clear picture of this logic

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define mapplet?

1000

What are the limitations of joiner transformation?

1093

What is a snowflake schema?

980

What is informatica etl tool?

989

what is INFORMATICA TESTING process

2280

What is pmcmd command?

1088

Why do you use Mapping Parameter and mapping variable?

1747

What is meant by a domain?

1114

What are the advantages of informatica?

998

what are the Methods For Creating Reusable Transformations?

1158

complex mapping ur project u r invlve can u explain and give real time example give me ?

2275

How can we handle two sessions in informatica?

1021

What is sq transformation?

1140

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2439

Explain the types of lookup transformation?

1035