Databases Reference
In-Depth Information
Script layout
Besides tabs, comments, and an information sheet, using a proper layout for your
script greatly increases readability. It is recommended to use indentation to visualize
the different levels in your script. It is also recommended to align all of your aliases
(the field name after the
as
part in
LOAD
statements). Compare the following script to
the commented script shown earlier and you will notice that it is much easier to read.
Naming conventions
Lastly, it is recommended to use naming conventions and to use these consistently
throughout your script. We will now have a look at the naming convention that is
being used for the documents in this topic.
Table naming conventions
Tables that will be used in the final data model have a "business" name that is in
plural. That means, a business user understands what is stored in the table. So
instead of naming our table
CST_DATA
, we name it
Customers
. This also means that it
is permissible to have spaces in our table names.
