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
- 7 Answers
- 7742 Views
- I also Faced
- E-Mail Answers
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
What is the meaning of up gradation of repository?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to do unit testing in informatica? How to load data in informatica ?
What is a node in Informatica?
What is the function of aggregator transformation?
Where are the source flat files kept before running the session?
What are the different types of olap? Give an example?
can you please explain me pre session and post session options?
Differentiate between joiner and lookup transformation?
what is the size of u r source(like file or table)?
Difference between Target-based loading and constraint-based loading?
What is aggregate cache in aggregator transformation?
How to configure mapping in informatica?
What is dimensional table? Explain the different dimensions.
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
