design of staging area?
No Answer is Posted For this Question
Be the First to Post Answer
Which are the different editions of informatica powercenter that are available?
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?
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
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?
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.
Which is costliest transformation? costly means occupying more memory?
how to get max value record into one target and remaining records into another target?
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What are the disadvantages of Sequence Generator T/R?
Enlist the tasks for which source qualifier transformation is used.
what is data driven?
How do you load only null records into target?