Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12567 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is incremental aggregation?
How to open an older version of an object in the workspace?
Explain transaction control transformation in informatica
What are the components of Informatica? And what is the purpose of each?
What are the tasks that source qualifier perform?
Sequence generator, when you move from develoment to production how will you reset
What is sorter transformation?
What are the modules in Power Center
lookup transformation with screenshots
Mention a few design and development best practices for informatica?
What is the difference between informatica 7.0 and 8.0?
Enlist the differences between database and data warehouse.
What is Index Caches size?
What are the measure objects?
