design of staging area?


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

Post New Answer

More Informatica Interview Questions

Which are the different editions of informatica powercenter that are available?

0 Answers  


I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,


SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,


One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 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,






Which is costliest transformation? costly means occupying more memory?

3 Answers  


how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,


By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  


What are the disadvantages of Sequence Generator T/R?

3 Answers   Zensar,


Enlist the tasks for which source qualifier transformation is used.

0 Answers  


what is data driven?

1 Answers  


How do you load only null records into target?

0 Answers  


Categories