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 / 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
wf dont have integration severances how you can run?
Explain dynamic target flat file name generation in informatica
How we can use union transformation?
How can we handle two sessions in informatica?
How do you set a varible in incremental aggregation
Explain about Informatica server process that how it works relates to mapping variables?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What could be the possible resons of locks by user?
How to load the data from people soft hrm to people soft erm using informatica?
What is confirmed fact in dataware housing?
What are the differences between a connected lookup and unconnected lookup?
Parameter and variable differences
What are the components of workflow manager?
What is persistent lookup cache?
On which transformations you created partitions in your project?