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
- 9673 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 |
How will u find weather dimension table is big in size of a fact table?
Difference between Data and Index Caches?
Which one is better performance wise connected/un-connected lkp?why?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
While importing the relational source defintion from database,what are the meta data of source U import?
How to create the source and target database connections in server manager?
Explain the code page compatibility?
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
what is the difference between mapplet & stored procedure?
what is confirmed fact?
What is the Router transformation?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
Teradata 
