Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is workflow manager?

0 Answers  


My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,


difference between stop and abort

2 Answers  


what transformations are used for Variable port?

2 Answers  


can we use self join in informaitca?

3 Answers   IBM,






What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,


How we can use union transformation?

0 Answers  


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

7 Answers   IBM,


Categories