Interested to Buy Any Domain ? << Click Here >> for more details...
three ways sql*loader could load data, what are those three
types?
- 1 Answers
- 4804 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 ddl (data definition language)?
What are modeling tools available in the market?
What are session timeout and application timeout? Where we have to do this process?
What are the different methods of loading dimension tables?
Explain what is the difference between view filter and report filter?
Explain what is analytical or analytic mean?
Difference between e-r modeling and dimentional modeling?
How do we design a universe?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is the metadata extension?
Explain what are the advantages and disadvantages of reporting directly against the database?
How are models actually derived?
What is a staging area? Do we need it? What is the purpose of a staging area?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
