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 / 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
r u done any partitions in ur project?
Does an informatica transformation support only aggregate expressions?
what is song in infrmatica...?
whats the logic to load the lower level of granularity of data to fact table.
Differentiate between a repository server and a powerhouse?
How many input parameters can exist in an unconnected lookup?
Explain why we use partitioning the session in informatica?
Explain Dataware house architecture .how data flow from intial to end?
How to generate sequence numbers?
On which transformations you created partitions in your project?
What is the session task and command task?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a filter transformation and why it is an active one?
What is workflow manager?
What does “tail –f” command do and what is its use as an Informatica admin.