Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?

Answer Posted / 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...!

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a pre-defined event and user-defined event?

976


can anyone suggest best free Talend data integration training online

1623


scenario where i can use only concurrent execution of workflow.

3067


Clarify the aggregator change?

972


How many numbers of sessions can one group in batches?

1015


What is target load order?

1190


How can we use mapping variables in informatica? Where do we use them?

1101


Explain sessions. Explain how batches are used to combine executions?

954


What are Dimensional table?

1002


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2310


How do you load only null records into target? Explain through mapping flow.

1958


How do you load only null records into target?

1145


draw informatica architecture 8.6 ?

3823


What is the function of union transformation?

1067


What is decode in static cache?

1082