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
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
What are ETL Tools?
What is informatica metadata and where is it stored?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
can u any challenge your project?
how to load dimension table and fact table. plz tell me the steps.
what are the deliverables?in your project?
How can we use mapping variables in informatica?
How do you load only null records into target? Explain through mapping flow.
How can you increase the performance in joiner transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is dimensional table? Explain the different dimensions.
What are connected or unconnected transformations?
How many ways are there to create ports?
What is data movement mode in Informatica and difference between them?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you