Explain the etl program with few examples.
No Answer is Posted For this Question
Be the First to Post Answer
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
how can u tune u r informatica mapppings
When do you use mapping parameters? (In which transformations)
What is the difference between unicode & ascii mode data movement in informatica?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
when informatica 8 series released ?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
how to load only the first and last record of a flat file into the target?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me