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
- 10495 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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to convert multiple rows to single row (multiple columns) in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What do you understand by a term domain?
What does “tail –f” command do and what is its use as an Informatica admin.
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to go to the older version for a mapping?
explain one complex mapping with logic? sales project?
Design a mapping to load the cumulative sum of salaries of employees into target table?
explan ur project architecture?
Make a note of the quantity vaults made in informatica?
Can you use flat files in Mapplets.
What is the format of informatica objects in a repository?
Which version configuration tool used in ur project?
