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
- 7674 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / niru
select name,salary from emp
union
select "total",sum(sal) from emp
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
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)
What is informatica metadata and where is it stored?
Whats there in global repository
Which is the t/r that builts only single cache memory?
What is a repository? And how to add it in an informatica client?
Different qualification between a related rotate toward the sky and isolates look upward?
Explain lookup transformation source types in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the tuning techniques you applied during your last project
What are the main features of Oracle 8i with context to datawarehouse?
What is the use of source qualifier?
How do you load alternate records into different tables through mapping flow?
Explain the etl program with few examples.
How do you load first and last records into target table?
Enlist some properties of sessions.
