Follow

What is the "_M" table and what are the deployment steps

The Message table contains the error messages that can be displayed as result of the validation performed in the data cleansing process.

The messages are created automatically based on the implicit and explicit validation rules defined in timeXtender, such as primary key check, relations and field level validation rules. There is currently no supported way of entering custom error messages.

The severity flag in the Message table determines if the message is considered as a warning or error.

Using the List table, one record in the Raw table can be associated with one or more messages from the Message table.

The deployment happens in the following steps

  1. Drop any user-defined functions used by the table
    1. Find by timeXtender object ID and type
    2. Find by name and schema
    3. Find by name in default schema (dbo)
  2. Drop existing table
    1. Find by name and schema
    2. Find by timeXtender ID and type
    3. Find by name in default schema (dbo)
  3. Create new table
    1. Table is tagged with timeXtender object ID and type using extended properties
  4. Create new functions
    1. User-defined functions are tagged with timeXtender object ID and type using extended properties

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.