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 native users?

0 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,


What are active and passive transformations?

0 Answers   Informatica,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,






What you know about transaction control transformation?

0 Answers  


What is a repository manager?

0 Answers  


we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,


Explain the code page compatibility?

0 Answers  


what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,


What are the advantages of informatica?

0 Answers  


Define mapping and session?

0 Answers   Informatica,


Categories