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
- 7698 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
Differentiate between Load Manager and DTM?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to improve the performance of a session using sorter transformation?
How you can differentiate between connected lookup and unconnected lookup?
where to store informatica rejected data?
What are the restrictions of union transformation?
wat are deployement groups in informatica, how it will be used for developers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain lookup transformation in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Is it possible to define a single node as a Gateway node as well as worker node?
Explain the different kinds of facts.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we create multiple integration service on single repository?
Explian the Process of deployment groups in informatica
