BETL meta data consists of the following:
- An object meta data database about columns, tables, views, schema's, databases and servers. This is stored in the tables:
meta._Object
his._Column
Each object has a default
transfermethod_id. This can be set per object or per schema, database or server.
The default
transfermethod_id determines the TSQL template that is generated when the push command is invoked. Example transfer methods are:
- truncate_insert
- drop_insert
- Datavault Hub & Sat (CDC and delete detection)
- Datavault Link & Sat (CDC and delete detection)
- Kimball Dimension
- Kimball Fact
- Kimball Fact Append
- A job and logging database storing Jobs, batches, steps and step_instances. Usage is optional.
- Configuration. persistent settings like target_schema_id, recreate_tables. These properties are related to database objects (this can be a table, but also an entire schema or database). Properties are inherited. Properties can be set by using betl.dbo.setp. Properties can also be related to users. E.g. exec_sql and log_level
