three ways sql*loader could load data, what are those three
types?
- 1 Answers
- 4359 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is "method/1"?
What is a linked cube?
Define data warehouse?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain normalization?
Where the cache files stored?
Explain what are the various file formats involved in reportnet?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain how to export mappings to the production environment?
How to improve session performance in aggregator transformation?
What are the different ways to represent the loading of dimension tables?
What is the data type of the surrogate key?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are aggregate tables and aggregate fact tables?
How to pivot data using informatica when you have variable amount of pivot rows?
