Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 10503 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
Explain the use of aggregator cache file?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Describe the impact of several join conditions and join order in a joiner transformation?
What is joiner transformation?
What do think which one is the better joiner or look up?
What is a repository manager?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Define filter transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is a dimensional model?
What is decode in static cache?
How do you change a non-reusable transformation to reusable transformation?
Make a note of the quantity vaults made in informatica?
what are 3 tech challenges/ common issues you face?
Enlist some properties of sessions.
