Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table like
empid ename year month sal
1 x 98 jan 500
1 x 98 feb 500
1 x 98 mar 500
1 x 99 jan 600
1 x 99 feb 600
2 y 98 jan 600
2 y 98 feb 600
2 y 98 mar 600
2 y 99 jan 700
2 y 99 jan 700
and so on
i want to find out totsal for every emp on year wise
plz help me
- 2 Answers
- 5821 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumarvijay
If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do you load first and last records into target table?
What is data movement mode in Informatica and difference between them?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
lookup transformation with screenshots
How many types of sessions are there in informatica.please explain them?
What is a node in Informatica?
What are the databases that informatica can connect to windows?
Different qualification between a related rotate toward the sky and isolates look upward?
How to create the source and target database connections in server manager?
How many ways are there to do 'remove duplicate records in informatica'?
Separate from an archive server and a powerhouse?
What is rank transformation in informatica
What are the guidelines to be followed while using union transformation?
