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
- 1487 Views
- Cap Gemini, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
scenario where i can use only concurrent execution of workflow.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Performance tuning( what you did in performance tuning)
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
What are mapplets?
if i am having 10 records in source, i want 20 records in target...how will you do it
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
what happens if you try to create a shortcut to a non- shared folder?
Differentiate between Load Manager and DTM?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Teradata 
