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
- 4 Answers
- 10888 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / sachin
use an aggregrator where you need to check the group by
port as emp id, ename and year.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Can you generate sequence numbers without using the sequence generator transformation?
What are ETL Tools?
my source is junk data how will u remove that junk data by using unix please any one replay me
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How do you set a varible in incremental aggregation
expain about the tune parameters?
What are the guidelines to be followed while using union transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can u give example for factless fact table
What is mapplet in informatica?
What is informatica worklet?
Explain the difference between a data warehouse and a data mart?
What is DR strategy for Informatica project?
