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 to join three sources using joiner?
Define sessions in informatica etl?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the differences between source qualifier and joiner transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is session task and command task?
What could be the possible resons of locks by user?
Explain incremental aggregation in informatica
can we override a native sql query within informatica? Where do we do it?
Explain dynamic target flat file name generation in informatica
what are 3 tech challenges/ common issues you face?
How can we delete duplicate rows from flat files?
What are the different types of transformation available in informatica.
Can u generate reports in Informatica?
Plz can any one say me how to get the informatica certification materials and dumps