How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)
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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Which transformation is needed while using the Cobol sources as source definitions?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How can you differentiate between powercenter and power map?
What is update strategy transform?
How do you migrate data from one environment to another?
What is standalone command task?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
how tokens will generate?
How to call shell scripts from informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Differentiate between router and filter transformation?
What is the use of an aggregator cache file?
In how many ways we can create ports?
Target increases every day even though no new record was inserted