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
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 the hint? how to use it to reduce the query processing in program?
What you know about transaction control transformation?
What is the need of etl tools?
Please let me know how to make Data masking in informatica..
How many numbers of sessions can one group in batches?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is rank transform?
How can a transformation be made reusable?
What is the status code in stored procedure transformation?
How can we update a record in the target table without using update strategy?
When do you use sql override in a lookup transformation?
How to create the source and target database connections in server manager?
what is mean by complex business rule ?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the types of schemas we have in data warehouse.