if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 7744 Views
- I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Use aggrigator transformation group by port as eno
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is domain in terms of informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What do you understand by term role-playing dimension?
What are the various types of transformation?
Make a note of the quantity vaults made in informatica?
How can we use batches?
design of staging area?
What is blocking transformation?
Enlist some properties of sessions.
How can we update a record in the target table without using update strategy?
What is status code in informatica?
What does command task mean?
Why filter transformation is an active one?
How to update or delete the rows in a target, which do not have key fields?
How to extract sap data using informatica? What is abap? What are idocs?
