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
- 11029 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
Design a mapping to load a target table with the following values from the above source?
Explain the shared cache and re-cache?
What are the different types of olap? Give an example?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain in detail about scd type 1 through mapping.
How many numbers of sessions can one group in batches?
How can we use batches?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Mention few advantages of router transformation over filter transformation.
What are the tuning techniques you applied during your last project
What does update strategy mean, and what are the different option of it?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is an active transformation?
What is an aggregator transformation?
Differentiate between Load Manager and DTM?
