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
- 1263 Views
- Cap Gemini, I also Faced
- E-Mail Answers
select count(1) from emp? what is the o/p?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
what is normalizer transformation?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
what is fact table?
how to run the batch using pmcmd command
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
what is dynamic cashe
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
In session log thier should not be a single error how will u do
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
Teradata 
