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.
Answer Posted / sony_infa
using session partition we can improve the performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
list out all the transformations which use cache?
What is difference between a gateway node and worker node?
what is the difference between informatica6.1 and infomatica7.1
Explain the types of lookup transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is enterprise data warehousing?
How can we handle two sessions in informatica?
What is informatica metadata and where is it stored?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is InformaticaPowerCenter?
What are the guidelines to be followed while using union transformation?
Can we override a native sql query within informatica?
What are the different options available for update strategy?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs