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
What is a pre-defined event and user-defined event?
can anyone suggest best free Talend data integration training online
scenario where i can use only concurrent execution of workflow.
Clarify the aggregator change?
How many numbers of sessions can one group in batches?
What is target load order?
How can we use mapping variables in informatica? Where do we use them?
Explain sessions. Explain how batches are used to combine executions?
What are Dimensional table?
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 ?
How do you load only null records into target? Explain through mapping flow.
How do you load only null records into target?
draw informatica architecture 8.6 ?
What is the function of union transformation?
What is decode in static cache?