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
- 7641 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pooja
Select case when GROUPING(e.Name)= 1
then'Total'else e.Name end as Name,
sum(e.Salary)as Salary from Emp e
group by e.Name with rollup
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many dimensions are there in informatica?
draw informatica architecture 8.6 ?
tell me 5 session failure in real time how can you solve that in your project?
What is Index Caches size?
What is workflow? What are the components of workflow manager?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are Dimensional table?
What is substr in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
What is dynamic cache?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the difference between a data warehouse and a data mart?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How are the sources and targets definitions imported in informatica designer?
whats the logic to load the lower level of granularity of data to fact table.
