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 .

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,

---

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

---

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

---

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

---

what is the difference between request group and request security in oracle apps?

1 Answers  

---

is it possible to run the interface without using oracle apps?

0 Answers  

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  

---

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,

---

where u do setup of operating unit?

1 Answers   TCS,

---

what are the different transaction clauses in AR?

0 Answers   BirlaSoft,

---