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
- 8891 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
Explain Dataware house architecture .how data flow from intial to end?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a standalone command task?
What is the maplet?
According to his methodology what all you need before you build a datawarehouse
What is the reusable transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How to go to the older version for a mapping?
Can anyone tell me the new features in Informatica 9 Version?
Design a mapping to load a target table with the following values from the above source?
What is a passive transformation?
Explain the etl program with few examples.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How does the aggregator transformation handle null values?
What are the types of caches in lookup? Explain them.
