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 / 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 |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is dimensional table?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the types of caches in lookup?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Which files are created during the session rums by informatics server?
What are the restrictions of union transformation?
What are junk dimensions?
Define enterprise data warehousing?
What is the command used to run a batch?
What is workflow? What are the components of the workflow manager?
Where do we use mapping variables in informatica?
What are multi-group transformations?