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
In informatica workflow manager, how many repositories can be created?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
difference between repository database and repository service?
What is meant by a domain?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain sessions?
What are the differences between a connected lookup and unconnected lookup?
How to generate sequence numbers?
Explain Dataware house architecture .how data flow from intial to end?
my source is junk data how will u remove that junk data by using unix please any one replay me
Whats there in global repository
What differs when we choose the sorted input for aggregator transformation?
Can you generate sequence numbers without using the sequence generator transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Make a note of the quantity vaults made in informatica?