Design a mapping to calculate department wise sum of salaries and load it in single target?
Source Target
Deptno Salary Deptno Salary
10 100 10 600
10 200 10 600
10 300 10 600
20 200 20 800
20 300 20 800
20 300 20 800
30 400 20 1500
30 500 30 1500
30 600 30 1500


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is incremental data aggregation?

3 Answers   IBM,


how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


Write the unconnected lookup syntax and how to return more than one column.

0 Answers  


What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,


You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,


What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,


what are testing in a mapping level please give brif eplanation

1 Answers   CTS,


What is the need of etl tools?

0 Answers  


Explain the different dimensions.

0 Answers  


Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


Categories