A Native ODBC-based load is similar to an ODBC load, except it provides a faster method to load data from non-linked databases.
A Native ODBC-based interactive load when using the WhereScape RED tool will use the established ODBC connection to pull the data back to a delimited file on the local PC and then push the data to the data warehouse database via a Bulk Insert in SQL Server.
A scheduler load will perform in the same way, except that the data is loaded into the server that is running the scheduler and then pushed to the data warehouse database.
All loaders require dates in the default format of the target data warehouse database. Both of these are normally achieved via a During load transformation, using the correct casting function for the source database.
The Properties and Storage screens for a Native ODBC-based load are the same as those of a database link load. Refer to the previous sections for details. Details of the source mapping screen follow.
If you are doing Native Loads using UNIX and LINUX, see the section Native Loads using UNIX and LINUX for more details about this type of load.