Interested to Buy Any Domain ? << Click Here >> for more details...
three ways sql*loader could load data, what are those three
types?
- 1 Answers
- 4662 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
explain about balanced dimension,
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Can we start and stop single session in concurent bstch?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
How can we do data cleaning?
Code the tables statement to produce a multi-level frequency?
Explain what are the possible data marts in retail sales?
Difference between cold fusion 5 and cold fusion mx 6?
What are the advantages and disadvantages of reporting directly against the database?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What are vaious etl tools in the market?
How can we load the time dimension?
Explain what are components of report studio?
What is cost benefit analysis (cba)?
