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
Which means the first record should come as last record and last record should come as first record and load into the target file?
Briefly define reusable transformation?
How to create a non-reusable instance of reusable transformations?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Design a mapping to load a target table with the following values from the above source?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can you differentiate between powercenter and power map?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How you know when to use a static cache and dynamic cache in lookup transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is index?how it can work in informatica
What are mapplets? How is it different from a Reusable Transformation?