Interested to Buy Any Domain ? << Click Here >> for more details...
if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 9103 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandra
After the source qulifier take Aggr t/r pass all the ports
to th Aggr t/r. group by eno & year.Add a new out put port
in this derive the logic as sum(sal) & pass to the Target
Def.
I think this would work.
Regards,
Chandra
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
What is olap (on-line analytical processing?
What is the difference between source qualifier transformations source filter to filter transformation?
What do you understand by term role-playing dimension?
What differs when we choose the sorted input for aggregator transformation?
What is parallel processing in informatica?
How can a transformation be made reusable?
How to load the data from people soft hrm to people soft erm using informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the tasks that source qualifier perform?
what are the deliverables?in your project?
Explain in detail scd type 2 through mapping.
What are the new features of informatica 9.x developer?
What is the benefit of partitioning a session?
What is meant by lookup transformation? Explain the types of lookup transformation?
