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


Please Help Members By Posting Answers For Below Questions

Can we get 1st record through Informatica(without sequence number).

938


How do we call shell scripts from informatica?

571


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?

609


What is a predefined event?

632


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

609






Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1525


What is a repository manager?

626


What is domain and gateway node?

668


What is decode in static cache?

574


Differentiate between sessions and batches?

545


What are the performance considerations when working with aggregator transformation?

653


How to do unit testing in informatica? How to load data in informatica ?

625


Global and Local shortcuts. Advantages.

1437


What is the need of etl tools?

579


What is rank transform?

581