Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7633 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
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
Different sorts of metadata that stores in the storage facility?
How identifying bottlenecks in various components of informatica and resolving them?
What are the main issues while working with flat files as source and as targets ?
What are the new features of informatica 9.x developer?
What is a filter transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the function of union transformation?
What is a repository? And how to add it in an informatica client?
where to store informatica rejected data? How to extract the informatica rejected data?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why do we need informatica?
What is a repository manager?
Explain pmcmd command usage in informatica
whats the logic to load the lower level of granularity of data to fact table.
What are the limitations of joiner transformation?
