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
use session partition to improve the performance.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What is different between the data warehouse and data mart?
What is standalone command task?
How to do the error handling of if ur source is flatfiles?
Briefly define a session task?
How will the document be delivered to me?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the function of aggregator transformation?
Why update strategy and union transformations are active?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Explain joiner transformation in informatica