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 if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,


I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


replace multiple spaces with single space.

3 Answers   IBM,






hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


explain about lookup t/r?

1 Answers   IBM,


i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,


When the informatica server marks that a batch is failed?

2 Answers  


From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,


What is workflow monitor?

0 Answers  


how can i invoke pmcmd in command line prompt

1 Answers  


Categories