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 / shekar
After source qulifier add a expression transformation in
the expression transformation create out put port name it
as maxsal then derive the code for this out put port as
setmaxvariable(sal).
Then pass the output ports from expression to target table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
How union transformation is used?
What is the function of look up transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the different ways to implement parallel processing in informatica?
what is $$$$?
difference between informatica 8.1.1 and 8.6
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Describe expression transformation?
What are the types of schemas we have in data warehouse.
What is an Integration service in Informatica?
Explain direct and indirect flat file loading (source file type) - informatica
What is standalone command task?
What is the procedure for creating independent data marts from informatica 7.1?
What is the scenario which compels informatica server to reject files?