three ways sql*loader could load data, what are those three
types?



three ways sql*loader could load data, what are those three types?..

Answer / sivakumar

SQL*Loader provides the following methods to load data:

Conventional Path Loads, Direct Path Loads, External Table
Loads

Conventional Path Loads: During conventional path loads,
the input records are parsed according to the field
specifications, and each data field is copied to its
corresponding bind array. When the bind array is full (or
no more data is left to read), an array insert is executed.

Direct Path Loads: A direct path load parses the input
records according to the field specifications, converts the
input field data to the column datatype, and builds a
column array. The column array is passed to a block
formatter, which creates data blocks in Oracle database
block format. The newly formatted database blocks are
written directly to the database, bypassing most RDBMS
processing. Direct path load is much faster than
conventional path load, but entails several restrictions.

External Table Loads: An external table load creates an
external table for data in a data file and executes INSERT
statements to insert the data from the data file into the
target table.


Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

How do you create surrogate key using ab initio?

0 Answers  


What are fundamental stages of data warehousing?

0 Answers  


Ist the schema that a data warehouse system can implements.

0 Answers  


Are facts same as metrics and dimensions same as measures? If not , please tell the difference?

1 Answers   Patni,


Explain grouped cross tab?

0 Answers  


What is the difference between drill through and masterdetail reports?

0 Answers  


Explain what are data marts?

0 Answers  


Explain what is analytical or analytic mean?

0 Answers  


How to load the time dimension?

0 Answers  


How can you implement many relations in star schema model?

0 Answers  


What is data analysis? Where it will be used?

0 Answers  


wht is degenerated dimension ?it's uses?

10 Answers   CTS, Infosys,


Categories