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
- 974 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is standalone command task?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What will be the approach?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What is difference between stored procedure transformation and external procedure transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
what is the need of session partitioning... how it is useful in real time
in static and dynamic which one is better
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how to import multiple flat files in to single target where there is no common column in the flat files
Teradata 
