source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000
- 7 Answers
- 11541 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 the difference between router and filter?
Why update strategy and union transformations are active? Explain with examples.
Why sorter is an active transformation?
How can we use batches?
How do you convert single row from source into three rows into target?
What is the different lookup cache(s)?
How to generate sequence numbers?
Scheduling properties,whats the default (sequential)
Informatica settings are available in which file?
Explain the difference between mapping parameter and mapping variable?
What is the maplet?
What do you mean by enterprise data warehousing?
Which files are created during the session rums by informatics server?
Explain scd type 3 through mapping.
Enlist the differences between database and data warehouse.
