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.

How do we design a universe?

938

---

if you use oracle sql*loader , how do you transform data with it during loading?

2100

---

What is operational data store (ods)?

1013

---

How to eliminate duplicate rows from flat file?

937

---

What is a view as it relates to system modeling?

979

---

What are components of report studio?

1043

---

What are modeling tools available in the market?

971

---

I need a good brd and uc template?

1074

---

How can you import tables from a database?

1081

---

what are the major three types of modeling used?

1063

---

What is normalization, first normal form, second normal form, third normal form?

964

---

What is type 2 version dimension?

972

---

How can you set the client management?

1014

---

Do you view contain data?

930

---

Explain how to export mappings to the production environment?

977

---