How to load data in informatica ?
No Answer is Posted For this Question
Be the First to Post Answer
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
how to load dimension table and fact table. plz tell me the steps.
What is an unconnected transformation?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
Which is the t/r that builts only single cache memory?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Can yoU use the maping parameters or variables created in one maping into another maping?
Which is better performance wise database or file?How?
how to declare array in plsql?