Tell me some thing about SQL-LOADER.
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 9 Yes | 1 No |
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 .
Is This Answer Correct ? | 5 Yes | 1 No |
What are the different components you should consider while defining a responsibility in oracle apps?
can we execute one concurrent program through another concurrent program?
Tell me some errors names and number what u got while developing the reports?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
while doing the process of conversion if got any data error out what is the next step to reprocess
How to print invoice from APPS(front end).if we have invoice number in hand with us???
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
The report output is 10 pages then how many times between pages report trigger will fire?
Explain oracle apps architecture.
Difference between triggers and procedures?
How to register a form and stored procedure in oracle apps
how many sections are there in report?