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
- 7268 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 parallel processing in informatica?
Clarify the aggregator change?
What is the maplet?
What is meant by LDAP users?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain what are the different versions of informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can you please explain me pre session and post session options?
Enlist the advantages of informatica.
How to use pmcmd utility command?
What is the difference between Active and Passive transformation?
Briefly define a session task?
Clarify the utilization of aggregator cache record?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What do you understand by SOA of Informatica?
