Scenario is like this:
Name Sal
A 10;
B 20;
C 30;
Then Output should be
Name Sal
A 10;
B 20;
C 30;
Total 60;
Use SQL For this scenario
Answer Posted / niru
select name,salary from emp
union
select "total",sum(sal) from emp
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is difference between a gateway node and worker node?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is dynamic cache?
What is meant by lookup transformation?
what is unit testing?tell me proceedure
What is rank transform?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is Data Caches size?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How can we use mapping variables in informatica?
What are roles and groups and benefits of using them?
In warehouses how many schemas are there?
What are the types of schemas we have in data warehouse.
What is the maplet?