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
- 11121 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 limitations of joiner transformation?
Explain dynamic target flat file name generation in informatica
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to handle decimal places while importing a flatfile into informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Define mapplet?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Global and Local shortcuts. Advantages.
What are the conditions needed to improve the performance of informatica aggregator transformation?
Explain the shared cache and re-cache?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a connected transformation?
