Answer / chinni

1tera data is huge amount of data so if we use normal load
type it takes so much of time....to overcome this better to
use bulk loading...and also taking the large commit
intervals we can get good performance....and one more
technique is external loading.....

Answer / james

I agree with you Chinni.
But my suggestion is instead of loading huge amount of data
at a time,we can always split the source if it is a file
using unix and extract the data from all the source files
using indirect type and load into target.

Please let me know if you have any suggestions.

Thanks.
James.

Answer / vasu

Always Partition is the best option for huge volume

Answer / chiranjeevi k

We can use push down optimizationto to handle the huge
volume of data.

Thanks
Chiranjeevi

Answer / bakshu shaik

one more thing we need to take into consideration, along with above suggestions:

If the target having an index, Loading time (huge amount of data) increases/performance hazard......so it's always better to drop the index before loading(Stored procedure transformation) and create again after loading completed...!

Answer / sudheer113

Along with the above suggestions......

Better to use partitioning (single or multiple thread) and and increase the commit level to 50 lacs. Better to load first flat file instead of loading into table.
then if u r db is oracle better to use sql loader to load data from file to table.If DB2 than use db2 loader.

Answer / upendra

large amount of data in source file.So we can devide partitions and commit level ur own wish,then connected to different target table, each one target table better for bulk load.

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

How can you join two tables without any common column present in them?

1 Answers   TCS,

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

how can u tune u r informatica mapppings

2 Answers   CTS,

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

What is a poling?

2 Answers  

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

Enlist the differences between database and data warehouse.

0 Answers  

how will you get 21 to 30 record from 50 records?

6 Answers  

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,