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
- 10498 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
Actually this question is - If any record have duplicate value then put it in T1 and If count is 1 then put in T2.
We have to use aggregator and have to group records based on empid and name
If count(empid) > 1 then T2
If count(empid) =1 then T1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly describe lookup transformation?
Plz can any one say me how to get the informatica certification materials and dumps
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the function of union transformation?
What is rank index in rank transformation?
What is the command used to run a batch?
How to create the source and target database connections in server manager?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Mention some types of transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What is the use of an aggregator cache file?
What is a difference between complete, stop and abort?
Why update strategy and union transformations are active? Explain with examples.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How to go to the older version for a mapping?
