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
- 8827 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
explan ur project architecture?
What is the function of look up transformation?
What is aggregator transformation in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the way to execute pl/sql script using informatica mapping?
Slowly changing dimensions, types and where will you use them
Difference between Target-based loading and constraint-based loading?
Reusable transformation and shortcut differences
Explain the types of lookup transformation?
What is rank index in rank transformation?
Explain the different dimensions.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Define mapplet?
