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 .

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

why r u move in the cus_top only why not move another top

4 Answers  

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---

---

When you run he report you have to get only that particular organization po numbers or item number how can do it?

2 Answers   IBM,

---

What are the User PARAMETERS in the Reports?

6 Answers   Accenture, CTS,

---

What is request group

4 Answers   Accenture,

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

List the types of flexfield?

0 Answers  

---

what is meant by lexical parameter

1 Answers   Wipro,

---

What is Value Set?

2 Answers   Accenture,

---