What are the components of Informatica? And what is the purpose of each?
No Answer is Posted For this Question
Be the First to Post Answer
How to enter same record twice in the target table,explain?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
What can we do to improve the performance of informatica aggregator transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
can you avoid static cache in the lookup transformation? I mean can you
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What are mapping parametres and variables in informatica?
Explain in detail scd type 2 through mapping.
What are the associated ports in look up T/R.
How to recover sessions in concurrent batches?