Answer / emmanuel - tcs

Sql * loader used to transfer Huge data from legacy to
oracel database. It's supports .dat,.xls etc.. files.

5 types of files are there.

Flat file -- .dat file
Control file -- Control file program
Bad file -- Stores the all error records
Discard file -- stores all the discard filed (WHEN Condi)
Log file -- Shows the status of the Control file

Thanks
Emmanuel - TCS

Answer / guest

Sql * loader is a bulk loader utility used for moving data
from external files into the oracle database.
Sql * loader supports various load formats, selective
loading, and multi-tables loads.
1) conventional
--The conventional path loader essentially loads the
data by using standard ?insert? statement.
2) direct
-- the direct path loader (direct = true)
by possess of logic involved with that, and loads directly
in to the oracle data files.
EX:-
My data.csv file
1001, ?scott tiger?,1000,40
1002,?gvreddy?,2345,50
Load data
Infile ?c:\data\mydata.csv?
Into table emp
Fields terminated by ?,? optionally enclosed by ???
(empno, empname,sal,deptno)
>sqlldr scott/tiger@vis
control=loader.ctl log= gvlog.log bad=gvbad.bad
discard=gvdis.dsc .

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

Cycle of requestion to receving transaction.

1 Answers   Accenture,

---

Can u attach Request set with in the Request set?

2 Answers   Satyam,

---

What is the most critical part which you had faced in your project ?

1 Answers   LG, Satyam, Tech Mahindra,

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

---

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

How to create a purchase order without a requisition?

0 Answers  

---

why we can use synonym?

6 Answers  

---