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
- 5810 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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is informatica etl tool?
In development project what is the process to follow for an etl developer from day1
What are session parameters ? How do you set them?
What is informatica metadata and where is it stored?
What is union transformation in informatica?
How many numbers of sessions can one group in batches?
What all are steps in up gradation of Informatica server?
What is an Integration service in Informatica?
Can you generate sequence numbers without using the sequence generator transformation?
What do you understand by term role-playing dimension?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why is sorter an active transformation?
Explain lookup transformation is active in informatica
