what are the other factors of the database on which the
loading performance depend?



what are the other factors of the database on which the loading performance depend?..

Answer / Mrs Arati Hyanki

Other factors affecting the loading performance in Oracle include the size and structure of the source data, the number of concurrent load processes, the available system resources (CPU, memory, I/O), the complexity of transformations, and the number and type of indexes on the target tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Explain what is the difference between a primary and secondary actor in use case modeling?

1 Answers  


What is prompt types of prompts?use of prompts syntax of prompt?

1 Answers  


What are diagrams?

1 Answers   InfoAxon Technologies,


wht is degenerated dimension ?it's uses?

10 Answers   CTS, Infosys,


How to import vsam files from source to target. Do we need a special plugin?

1 Answers  


Why fact table is in a normal form?

1 Answers  


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

1 Answers  


Explain what is the difference between datawarehouse and bi?

1 Answers  


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

1 Answers  


What is the very basic difference between data warehouse and operational databases?

1 Answers  


What is a fact, dimension, measure?

1 Answers  


what are the major three types of modeling used?

1 Answers   InfoAxon Technologies,


Categories