How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
Answer Posted / dev
Have index on the sources and make sure indexes are dropped in target(any ways these are distinct records) before load and opt for bulk loading. Once load is done you can create thee indexes again and maybe analyze the table also.
Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
tell me the rules and responsblites in our project(my project is development)
update strategy transformation in informatica
What are the transformations that are not supported in mapplet?
How we can create indexes after completing the load process?
What are the types of schemas we have in data warehouse and what are the difference between them?
Differentiate between router and filter transformation?
Explain the scenario which compels informatica server to reject files?
what are the Methods For Creating Reusable Transformations?
Define enterprise data warehousing?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
where to store informatica rejected data?
What is olap (on-line analytical processing?
On which transformations you created partitions in your project?
lookup transformation with screenshots
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?