What are the informatica performance improvement tips
No Answer is Posted For this Question
Be the First to Post Answer
What is the meaning of up gradation of repository?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can you access a repository created in previous version of Informatica?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
What are the join types in joiner transformation?
Explain the mapping variable usage example in informatica
What are the different types of transformation available in informatica.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Explain in detail scd type 2 through mapping.
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Why do you use Mapping Parameter and mapping variable?