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
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a shortcut and copy in Informatica and how two are different with each other?
Differentiate between sessions and batches?
What is status code in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain lookup transformation source types in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to extract the informatica rejected data?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Is it possible to create multiple domains on a single Informatica server?
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
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.