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 / kiran
SQL> select ename,sal from emp union select 'total:',sum(sal) from emp;
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
What is the session task and command task?
Describe data concatenation?
How to improve the performance of a session using sorter transformation?
Reusable transformation and shortcut differences
What is depict expression change?
how to load dimension table and fact table. plz tell me the steps.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
The question was on time stamp. what is the difference between HH and HH24 when to use when.
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to delete duplicate row using informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
In which transformation you cannot drag ports into it?
What is the scenario which compels informatica server to reject files?
What are the different versions of informatica?