using AGG we get can't get the above o/p

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

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

Answer Posted / krish

using AGG we get can't get the above o/p

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does a sorter cache works?

1043

Briefly define a session task?

1105

What do you mean by filter transformation?

938

What is rank transformation?

970

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1886

What is a node in Informatica?

1027

In informatics server which files are created during the session rums?

1105

What is informatica?

1130

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7014

what is the -ve test case in your project.

2392

How might you approve all mappings in the archive all the while?

1004

can anyone explain me about retail domain project in informatica?

7927

Name the different lookup cache(s)?

1212

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

953

How do you remove duplicate records in informatica? And how many ways are there to do it?

1153