can you please explain me pre session and post session options?
Answer Posted / abhinaw prakash
Pre session and post session.
Example: if we want to use bulk mode loading on index tables
it'll fail.
So its something like we can drop the index in pre session
command and again recreate the indexes once the data has
been loaded in post session.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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.
can u any challenge your project?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
To import the flat file definition into the designer where should the flat file be placed?
Explain the shared cache and re-cache?
What is a pre-defined event and user-defined event?
Explain constraint based loading in informatica
what is informatica metadata?
What is a joiner transformation?
What is pmcmd command?
How does a rank transform differ from aggregator transform functions max and min?
What is the difference between router and filter?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Enlist few areas or real-time situations where informatica is required.