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 / vikneswaran
use agg trans group by empid and year then use sum(sal)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is resilience time?
What do you mean by channel change?
Global and Local shortcuts. Advantages.
wf dont have integration severances how you can run?
What is joiner change?
How to create or import flat file definition in to the warehouse designer?
What are the types of caches in lookup? Explain them.
Did u used latest transformations of 8.6.0? for what?
What is primary and backup node?
What is aggregate cache in aggregator transformation?
What are the differences between source qualifier and joiner transformation?
generate date / time dimension in informatica
How would you copy the content of one repository to another repository?
Write the prerequisite tasks to achieve the session partition?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?