source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
Answer Posted / venkatesh malneni
source-->sq-
| \-------------|
| --->aggr--->target
in target create a new column maxsal now drag the source and
target to the mapping area connect the source to sq.from sq
create two pipelines connect the first pipeline to the target
and the second pipeline to the aggr t/r in aggr t/r create a
new port max_sal=max(sal) connect this pipe line to the target
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
How many input parameters can exist in an unconnected lookup?
What are ETL Tools?
How to do unit testing in informatica?
Target increases every day even though no new record was inserted
What is the need of etl tools?
Which transformation is needed while using the Cobol sources as source definitions?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is powercenter on grid?
What are some examples of informatica etl programs?
What is xml source qualifier transformation in informatica?
Why do we need informatica?
Explain lookup transformation in informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
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