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
- 10680 Views
- Magna Infotech, I also Faced
- E-Mail Answers
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 are data-driven sessions?
How can you define user defied event?
Quickly characterize reusable change?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what are the Methods For Creating Reusable Transformations?
can we override a native sql query within informatica? Where do we do it?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the procedure for creating independent data marts from informatica 7.1?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Can we get 1st record through Informatica(without sequence number).
what is degenerated dimension?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is union transformation?
What are the advantages of informatica?
