Select case when GROUPING(e.Name)= 1 then'Total'else e.Name end

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

Question Posted / pooja

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

Please Help Members By Posting Answers For Below Questions

where to store informatica rejected data?

695

What is the difference between source qualifier transformations source filter to filter transformation?

594

What are the new features of informatica 9.x developer?

540

What are mapplets?

830

How to go to the older version for a mapping?

613

How to convert multiple rows to single row (multiple columns) in informatica

906

What is data transformation manager process?

630

Explain about Informatica server process that how it works relates to mapping variables?

639

Why sorter is an active transformation?

758

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1026

How union transformation is used?

600

What is the commit type if you have a transaction control transformation in the mapping?

661

can anyone explain me about retail domain project in informatica?

7447

complex mapping ur project u r invlve can u explain and give real time example give me ?

1853

What is the sequence generator transformation in informatica?

625