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
- 11057 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
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How identifying bottlenecks in various components of informatica and resolving them?
How to use procedural logic inside infromatica?
How to do unit testing in informatica? How to load data in informatica ?
Explain pmcmd command usage in informatica
In how many ways we can create ports?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is the size of your data warehousing?
How to update source definition?
How to generate sequence numbers using expression transformation?
Differentiate between source qualifier and filter transformation?
Explain in detail scd type 2 through mapping.
What is session task and command task?
Clarify the aggregator change?
What is status code in informatica?
