Associative model assumptions

In principle, each Load or Select statement creates one table in the data model. There are, however, some exceptions to this rule:

• If a loaded table contains exactly the same set of fields as an existing data table, the new table will not be created as a separate table. Instead, it will be appended to the existing table.

• If the Load or Select statement is preceded by the Concatenate keyword or Join, the loaded table will be merged with an existing data table.

• If the Load or Select statement is preceded by the Generic keyword, the loaded table will be transformed into several data tables.

• If the Load or Select statement is preceded by the Mapping or Semantic keyword, the loaded table will not be used as a normal data table.

• An existing table can be deleted using the Drop command.

Several Load statements will thus normally create a data model with several tables.

In the end of the script run, the existing tables will be evaluated. If the same field name is found in more...