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 / guest

Partition

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

wf dont have integration severances how you can run?

1538


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1036


What is mapping debugger?

566


What are the tasks that source qualifier perform?

627


Can we create a Integration service without a Repository service and vice versa?

720






How does a rank transform differ from aggregator transform functions max and min?

665


How to load the data from a flat file into the target where the source flat file name changes daily?

572


What are the types of schemas we have in data warehouse and what are the difference between them?

515


What are the components of Informatica? And what is the purpose of each?

613


State the differences between sql override and lookup override?

613


generate date / time dimension in informatica

712


What is a rank transform?

668


Write the prerequisite tasks to achieve the session partition?

636


What is the sequence generator transformation in informatica?

609


What is source qualifier transformation in informatica?

569