Create Table mode
Load all Tables in Schema has a Create Table mode. When this is specified, the tables being loaded are created from the source. This provides a very fast method for creating and loading a large number of tables.
Notes
- table-creation will be basic. Primary keys and indexes will not be included. To create tables more completely you should generate a DDL script and create the tables using this.
- for DB2 and Oracle users, before running the load, go to the Options tab and ensure that the correct Tablespace has been selected.
- when data is being loaded from Files and Excel Files, AQT will parse the files to determine the data types of the fields in the file.
- when data is being loaded from Files and Excel Files, and the First row has column names option is specified, AQT take the column names from this header row.
- Match tables is used to construct the name of the Table (being loaded) from the Load from Table. Note that this is opposite to way it normally works - which is for the Load from Table name to be constructed from Table (being loaded).