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 / pjr
SQ-->Agg-->TGT
in aggrigator create on new out_port max_sal=max(sal) then
give connection to tgt MXASAL
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How will the document be delivered to me?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the function of aggregator transformation?
Explain what transformation and how many are there in informatica?
What are mapplets?
waht type of interface is used for testing the data in informatica
How to extract sap data using informatica? What is abap? What are idocs?
What is meant by a domain?
How can we store previous session logs?
Is it possible to create multiple domains on a single Informatica server?
What are different types of transformations available in informatica?
What are the differences between oltp and olap?
How do you change a non-reusable transformation to reusable 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?
As union transformation gives UNION ALL output, how you will get the UNION output?