|
The following should be the configuration parameters for SQL*Loader mappings to obtain the best performance:
| Option Name |
Value |
| Deployable |
FALSE |
| Step type |
SQL*Loader |
| Bad file name, discard file name, log file name |
Keep blanks |
| Discard max |
0 |
| Continue load |
False (Applicable only for direct mode) |
| NLS character set |
Default value |
| Direct Mode |
FALSE |
| Operation Recoverable |
TRUE |
| Parallel load |
False (applicable only for mode) |
| Error Allowed |
99999 (means no limit) |
| Records to skip |
0 (for sales fact it will have some value as the initial rows have row count, total sales, total qty etc. It will be 1 for all the dims, lookups and facts as Column names exist in the file which needs to be skipped. |
| Records to load |
0 (means load all) |
| Rows per commit (No. Of rows in bind array) |
100 |
| Read size |
0 |
| Bind size (maximum size in bytes for bind array) |
40000 |
| Read buffers |
0 |
| Preserve blanks |
FALSE |
| Database file name |
Leave empty |
| Delimited record file termination |
Leave blank |
| Control file name |
Leave blank |
| Audit |
TRUE |
| Default purge group |
wb |
|
Informatica