Interested to Buy Any Domain ? << Click Here >> for more details...
How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
- 3 Answers
- 10919 Views
- Atriax, I also Faced
- E-Mail Answers
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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How identifying bottlenecks in various components of informatica and resolving them?
How to join three sources using joiner? Explain though mapping flow.
What is the use of code page?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the restrictions of union transformation?
Please let me know how to make encryption and decryption with example?
What are the tasks that can be performed using sq?
explain abt ur project architecture?
What are the main issues while working with flat files as source and as targets ?
what are the Methods For Creating Reusable Transformations?
Explain what transformation and how many are there in informatica?
How big was your fact table
How to join three sources using joiner?
waht type of interface is used for testing the data in informatica
