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
- 998 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
version controlling in informatica?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the -ve test case in your project.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the difference between Active and Passive transformation?
how to calculate the optimum cache size in aggregator transformation?
What is the default join that source qualifier provides?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
how will you get 21 to 30 record from 50 records?
Teradata 
