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
- 0 Answers
- 1097 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How we can create indexes after completing the loan process?
Implementation methodology
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain informatica architecture - version 8 / 9
What is the Router transformation?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is the Difference between sorter and aggregator?
In a sequential batch can u run the session if previous session fails?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What all are steps in up gradation of Informatica server?
Teradata 
