source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
- 7 Answers
- 11354 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Mention a few design and development best practices for informatica?
What are the tasks that source qualifier perform?
Explain dynamic target flat file name generation in informatica
which one is better performance wise joiner or look up
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How can one identify whether mapping is correct or not without connecting session?
What is sq transformation?
What is data caches/ index caches?
What are the types of data warehouses?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the use of an aggregator cache file?
Differentiate between sessions and batches?
What is a shortcut and copy in Informatica and how two are different with each other?
What differs when we choose the sorted input for aggregator transformation?
