Design a mapping to calculate department wise sum of salaries and load it in sin

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

Question Posted / veeruch8

0 Answers
1498 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Post New Answer

More Informatica Interview Questions

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers Keane India Ltd,

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers Cap Gemini, Cognizant,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers TCS,

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers TCS,

what is difference between COM & DCOM?

1 Answers Satyam,

How to load a Dimension ? and how to load a fact table?

0 Answers

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers HP,

How to load data in informatica ?

0 Answers

How to generate a single mapping for both the historical and incremental load.