Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7853 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / situ
first create a table emp4 using the above data then execute the below query to find that output
select case when grouping(name)=1 then 'Total'else name end as name,sum(sal) as sal from emp4 group by rollup(name);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
Explain sessions. Explain how batches are used to combine executions?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is workflow monitor?
Difference between Target-based loading and constraint-based loading?
What is Index Caches size?
Which transformation is needed while using the Cobol sources as source definitions?
lookup transformation with screenshots
What are the different components of powercenter?
what are factless facts? And in which scenario will you use such kinds of fact tables.
what is $$$$?
where to store informatica rejected data?
What is sq transformation?
What is joiner transformation in informatica?
how many types of dimensions are available in informatica?
