 Warning when using sql loader [message #251362] |
Fri, 13 July 2007 04:48  |
ssunda6
Messages: 28
Registered: June 2007
|
Junior Member |
|
|
Hi All,
I am using Datastage (an ETL Tool) to load data from a file to oracle table.
In oracle stage, when i specified UPSERT mode, I did not get any warnings.
But when used LOAD option(oracle in turn uses SQL Loader when specified this option), it is generating a warning:
Formatted length of fields and record (272) less than declared length (273)
In the control file, the record length is being shown as 272.
Any inputs would be of great help.
Thanx and regards,
ssunda
|
|
|
|
|
|
| Re: Warning when using sql loader [message #251376 is a reply to message #251363] |
Fri, 13 July 2007 06:52  |
ssunda6
Messages: 28
Registered: June 2007
|
Junior Member |
|
|
I couldnt figure out if the problem was with oracle or datastage.
Control file is the sql loader control file. It is automatically generated when we use LOAD option.
272 is the actual record length (as specified by sql loader control file)
The job appends data into oracle table. When we used UPSERT, performance of the job was low. Hence shifted to sql loader. The performance improved but this warning is coming. When UPSERT was used, we dint get this warning.
The records don't have field delimiters. Character set is EBCDIC and the data format is Binary.
Regards,
ssunda.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
