SQL LOADER
1. CONTROL FILE.
. Data File
2 BAD FILE SCENARIO
DATA FILE
BAD FILE:
3.DISCARD FILE SCENARIO
CONTROL FILE
Discard File
Log file
4.TRAILING
NULL COLS
CONTROL FILE
DATA FILE:
5.USING FILLER
6. POSITION BASED
DATA FILE(FIXED LENGTH DATA)
CONTROL FILE
DATA FILE
7. Control file
without data file
No comments:
Post a Comment