Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1542 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Is snow flake or star schema used? If star schema means why?
What are the types of schemas we have in data warehouse.
How are indexes created after completing the load process?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Whats the difference between $, $$, $$$
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
What are roles and groups and benefits of using them?
What happens if we dont select data driven option?
What is a repository? And how to add it in an informatica client?
State the differences between sql override and lookup override?
What are the prerequisite tasks to achieve the session partition?
Explain about the concept of mapping parameters and variables ?
Teradata 
