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
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
What are the tasks that source qualifier perform?
What if the source is a flat-file?
What is Index Caches size?
What is data caches/ index caches?
What is event and what are the tasks related to it?
Write the unconnected lookup syntax and how to return more than one column.
Write the advantages of partitioning a session?
what is the Default Source Option For Update Strategy Transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How an expression transformation differs from aggregator transformation?
In informatica workflow manager, how many repositories can be created?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is target designer and target load order?
What is blocking transformation?
what is the difference between informatica6.1 and infomatica7.1