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
- 1217 Views
- Cap Gemini, I also Faced
- E-Mail Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
If informatica has its scheduler why using third party scheduler?
What are mapping parametres and variables in informatica?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Do you find any difficulty while working with flat files as source and target?
What is the cumulative sum and moving sum?
How to elaborate tracing level?
what is incremantal aggregation?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
What is the difference between a router and a filter transformation?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
Teradata 
