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
- 993 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What are parallel querys and query hints?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the challenges you have faced in your project?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
hw cn v elimate dublicate values from lookup without overriding sql?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
Explain direct and indirect flat file loading (source file type) - informatica
Why filter transformation is an active one?
How can i set break points in debugging mode ? can explain steps please?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
Teradata 
