What is meant by lookup transformation? Explain the types of lookup transformation?
What are mapplets?
How do you implement scheduling in Informatica?
How do we call shell scripts from informatica?
can v update d records in target using update stargey without generationg primary key ? explain
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
How the facts will be loaded? explain
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
performance tuning of Informatica
Explain about Recovering sessions?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
What is flashback table ? Advance thanks