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
- 1485 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
major difference between normal loading and bulk loading?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Using Expression transformation how to remove duplicate records from a relational source?
Under which circumstances, informatica server creates reject files?
Describe two levels in which update strategy transformation sets?
What are batches?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
"Change cache" in Informatica ?
what is the logic will you implement to load data into a fact table from n dimension tables?
what is bridge tables in informatica
without dynamic lookup transformation how to insert new rows and update existing rows?
Teradata 
