Native Loads in Oracle
Some versions of Oracle do not return the ORACLE_SID correctly when an ODBC call requests it. To ensure that you don't have any issues because of this, please ensure that the following steps are followed:
If you are doing interactive Native Loads in Data Warehouse Designer into Oracle:
1 Ensure that the "Database id (SID)" field on the Data Warehouse connection properties screen is set to the actual ORACLE_SID for your database.
This value is used in the sqlldr connection during the native load IF the ORACLE_SID is not returned correctly by the ODBC driver.
If you are using the windows scheduler for Native Loads into Oracle:
1 Change the scheduler to be a direct path load (via maintain scheduler in the QAD Administrator).
2 Ensure that the TNS Service is set to the actual ORACLE_SID for your database.
3 Restart the scheduler.
This value is used in the sqlldr connection IF the SID is not returned by the ODBC driver and only IF the scheduler is set to do direct path loads.
Native ODBC Based Load - Source Mapping
The fields on the Source Mapping tab of the properties screen for Native ODBC loads are described below: