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 / 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
EXL informatica Questions
Explain the types of transformations?
where to store informatica rejected data?
How many numbers of sessions can one group in batches?
In which transformation you cannot drag ports into it?
What are the tuning techniques you applied during your last project
whats the logic to load the lower level of granularity of data to fact table.
Did u used latest transformations of 8.6.0? for what?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is DR strategy for Informatica project?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is rank index in rank transformation?
Define Pmrep command?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the differences between joiner transformation and source qualifier transformation?