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 / sujana

@above
wer do we calculate sum here..i think v shud create an o/p
port 4 sum.(sum sal) and grpby eno

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you use reject loader.

2187


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

700


What happens when a session fails and you click on recover?

744


What are the guidelines to be followed while using union transformation?

742


What is the function of union transformation?

713






How to update or delete the rows in a target, which do not have key fields?

761


What do you mean by channel change?

642


What are the tasks that source qualifier perform?

722


What is mapping debugger?

658


Global and Local shortcuts. Advantages.

1566


Name the different lookup cache(s)?

810


How to load a Dimension ? and how to load a fact table?

1044


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1735


Implementation methodology

1348


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

817