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
How do you use reject loader.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What happens when a session fails and you click on recover?
What are the guidelines to be followed while using union transformation?
What is the function of union transformation?
How to update or delete the rows in a target, which do not have key fields?
What do you mean by channel change?
What are the tasks that source qualifier perform?
What is mapping debugger?
Global and Local shortcuts. Advantages.
Name the different lookup cache(s)?
How to load a Dimension ? and how to load a fact table?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Implementation methodology
How to load the name of the current processing flat file along with the data into the target using informatica mapping?