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
- 11137 Views
- Atriax, I also Faced
- E-Mail Answers
Answer Posted / nitin tomer
1) Load Data using Bulk Load for that we have to drop index from the target table, but after loading the data to create the index will also take good amount of time
2) Create a sequence 1 to 100 million using sequence generator and create the pass-through partition to load data, let say 10 partition we can create from 1 to 100000 like that.
Partitioning will definitely give huge performance improvement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
explan ur project architecture?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the use of source qualifier?
What can we do to improve the performance of informatica aggregator transformation?
What are the main issues while working with flat files as source and as targets ?
What are the popular informatica products?
How to extract sap data using informatica?
What are the transformations that are not supported in mapplet?
How we can create indexes after completing the loan process?
How do you set a varible in incremental aggregation
what is the size of your data warehousing?
What is meant by LDAP users?
What are ETL Tools?
What is domain in terms of informatica?
