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 / suresh reddy
select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How many ways a relational source definition can be updated and what are they?
What is a mapplet/worklet in informatica?
Please let me know how to make encryption and decryption with example?
Can anyone tell me the new features in Informatica 9 Version?
What is the function of look up transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the designer tools for creating transformations?
Explain the features of connected and unconnected lookup.
Design time, run time. If you don't create parameter what will happen
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is SDLC way of code development?
Why is sorter an active transformation?
What are active transformations.