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
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 are the different clients of powercenter?
What is meant by active and passive transformation?
what is the size of u r source(like file or table)?
What does reusable transformation mean?
permutations of mapplet
Explain scd type 3 through mapping.
What is domain in terms of informatica?
what are the deliverables?in your project?
How big was your fact table
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain in detail scd type 2 through mapping.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain the tuning lookup transformation - informatica
Explain the difference between a data warehouse and a data mart?