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
Differentiate between Load Manager and DTM?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How does a rank transform differ from aggregator transform functions max and min?
what is SDLC way of code development?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the maplet?
Explain your project of banking domian.
Explain the features of connected and unconnected lookup.
what are the Methods For Creating Reusable Transformations?
generate date / time dimension in informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?