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
- 11058 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
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Informatica settings are available in which file?
explain about unit testing? in real time?
where to store informatica rejected data? How to extract the informatica rejected data?
What is the command used to run a batch?
What is event and what are the tasks related to it?
How to go to the older version for a mapping?
What is difference between a gateway node and worker node?
Have you worked with/created Parameter file
Define pmcmd command?
What are the advantages of using informatica as an etl tool over teradata?
Partition, what happens if the specified key range is shorter and longer
Explain informatica architecture - version 8 / 9
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Define sessions in informatica etl?
