How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Explain what are the different versions of informatica?
How to update source definition?
how to connect two or more table with single source qualifier?
what are the difference between Informatica 7.1 and 8.1?
What is meant by query override?
How will you convert rows into columns or columns into rows
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
What is meant by a domain?
What is an aggregator transformation?
How can i send first half of the records to one target and Remaining to other target?
What are the new features of informatica 9.x at the developer level?
What are the rank caches?