Interested to Buy Any Domain ? << Click Here >> for more details...
three ways sql*loader could load data, what are those three
types?
- 1 Answers
- 4803 Views
- I also Faced
- E-Mail Answers
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 |
What are the types of dimensional modeling?
For faster process, what we will do with the universe?
How do you create surrogate key using ab initio?
Store (and count) non-fact records?
What are the data marts?
Explain what are the possible data marts in retail sales?
Which are the olap tools available that are supported by oracle?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Disply the dname wise maximum salary
What needs to be done when the database is shutdown?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Explain what is batch and describe about types of batches?
Teradata 
