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
- 11310 Views
- Atriax, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the meaning of up gradation of repository?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How can we create index after completion of load process?
Difference between Target-based loading and constraint-based loading?
How to call shell scripts from informatica?
Define filter transformation?
Explain in detail scd type 2 through mapping.
Can u generate reports in Informatica?
How to generate sequence numbers?
Is there any way to read the ms excel datas directly into informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you load unique records into one target table and duplicate records into a different target table?
draw informatica architecture 8.6 ?
