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
Explain about Informatica server process that how it works relates to mapping variables?
What are session parameters ? How do you set them?
What are pre and post-session shell commands?
What is the Process to creating lookup transformation in informatica
Explain what transformation and how many are there in informatica?
How do you convert single row from source into three rows into target?
What is xml source qualifier transformation in informatica?
How can we use batches?
What is aggregator transformation in informatica?
Can we create a Integration service without a Repository service and vice versa?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is difference between a gateway node and worker node?
Explain lookup transformation in informatica
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 is update strategy transform?