SOURCE
NAME SAL
GANGA 30000
RAJU 20000
PAVAN 25000
TARGET
NAME SAL MAXSAL
GANGA 30000 30000
RAJU 20000 30000
PAVAN 25000 30000
in mapping level how to achive that
Answer Posted / davankumar
select name,sal,(select max(sal) from t1) from t1
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we get 1st record through Informatica(without sequence number).
How do we call shell scripts from informatica?
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?
What is a predefined event?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a repository manager?
What is domain and gateway node?
What is decode in static cache?
Differentiate between sessions and batches?
What are the performance considerations when working with aggregator transformation?
How to do unit testing in informatica? How to load data in informatica ?
Global and Local shortcuts. Advantages.
What is the need of etl tools?
What is rank transform?