source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / james
select name,no,sal,(select max(sal) from emp) as max_sal
from emp;
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Describe data concatenation?
What do you mean by blocking transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Have you worked with/created Parameter file
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is native users?
What is the difference between a connected look up and unconnected lookup?
What does update strategy mean, and what are the different option of it?
What is InformaticaPowerCenter?
What is the difference between Active and Passive transformation?
Where do we use mapping variables in informatica?
How we can create indexes after completing the load process?