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
- 4928 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
What happens when a session fails and you click on recover?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to update or delete the rows in a target, which do not have key fields?
Which transformation is needed while using the Cobol sources as source definitions?
What is decode in static cache?
What is the need for an etl tool?
What is the meaning of decode in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
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 are the types of caches in lookup?
What is the Rank index port in Rank transformation?
can anyone explain me about retail domain project in informatica?
Informatica Checkpoints
How many ways are there to create ports?
How can you increase the performance in joiner transformation?
