How to fasten loading of 100 million distinct records in
informatica?
(Initially they are loaded into target without using any
transformation, taking 2 hours)

Answers were Sorted based on User's Feedback



How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded ..

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

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded ..

Answer / guest

Partition

Is This Answer Correct ?    6 Yes 3 No

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded ..

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

More Informatica Interview Questions

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,


how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,


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

0 Answers   Informatica,


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,






Explain lookup transformation in informatica

0 Answers   Informatica,


what are presession,postsession success and postsession failure commands ?

1 Answers  


what is the size of u r source(like file or table)?

0 Answers   HP,


what is the flow?

1 Answers  


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


What is Java Transformation? what are the uses of it?

0 Answers   TCS,


What are session parameters ? How do you set them?

0 Answers  


Categories