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
- 11162 Views
- Atriax, I also Faced
- E-Mail Answers
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 |
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How do you promote a non-reusable transformation to reusable transformation?
What is InformaticaPowerCenter?
What is a filter transformation and why it is an active one?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
Whats the difference between $, $$, $$$
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
what is fact table?
What is decode in static cache?
How to display First letter of Names in Caps?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
comonly how meny mappings r there in Banking projects?
Teradata 
