Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me some thing about SQL-LOADER.
- 2 Answers
- 23629 Views
- IBM, I also Faced
- E-Mail Answers
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 and Who is the best Institute or Trainer for Oracle Apps Technical ?
How to generate XML Report with out using rdf?
6 Answers BirlaSoft, Patni, UST,
how i can create temporary table?
While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?
wht r the basetables of customer interface?
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
how to avoid duplicate data while uploading data from flatfile to staging table? some validations
What is the difference between base table and multi-org table?
what are the error tables in AP?
What are the validations you don in .CTL file in inbound interface process?
How to migrate .rdf file from dev instance to test instance?
3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,
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.
Oracle Apps Technical 
