Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 8823 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Use aggrigator transformation group by port as eno
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the settings that you use to configure the joiner transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to create Target definition for flat files?
How to open an older version of an object in the workspace?
What is the use of an aggregator cache file?
How to join three sources using joiner? Explain though mapping flow.
How do you take back up of repository?
What is a passive transformation?
COM components can be used in Informatica
Briefly define reusable transformation?
What the difference is between a database, a data warehouse and a data mart?
what is the -ve test case in your project.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the difference between writing a joiner query in ANSI style and THETA style?
