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
- 10931 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 |
Enlist the differences between database and data warehouse.
What is the commit type if you have a transaction control transformation in the mapping?
What is the command used to run a batch?
why we are using level option in normalizer transformation
What is the query to find nth highest salary? What is the use of cursors?
How you can differentiate between connected lookup and unconnected lookup?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain lookup transformation in informatica
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
Do you have to change the reject file b4 using reject loader utility.
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
tell me 5 session failure in real time how can you solve that in your project?
Teradata 
