Time+Machine Details

Element Details: Time+Machine

Available in: Logi Info

Source code name: TimeMachine

The Time Machine is an archive for data stored in a data mart table. Adding a Time Machine to a data mart table allows you to store snapshots of the table at different points in time. Any time the table is rebuilt or new rows appended, the same data rows are appended to the Time Machine table. An additional time-stamp column is added to the end of the Time Machine table to mark each data row at a particular moment in time.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

RowLifespan

UserDefined

(Required) Set this attribute to a number that specifies how many days a data row can live in the Tme Machine before being purged. For example, if the row lifespan value is 7, all data rows more than one week old get purged.

TimeStampColumn

UserDefined

Set this attribute to a date column from the source table to indicate that the Time Machine table should use the date column specified as the time-stamp column. By default, Logi Mart will populate the time-stamp column with the current date and time if no column is specified here.

UniqueIdentifierDataColumn

UserDefined

(Required) Specify the name of a column in the source table that acts as a primary key. Logi Intelligence Server will use this column to identify new rows added to the source table that are not present in the data mart table. NOTE: Use the @Function.UniqueIdentifierValue~ token to retrieve the current unique identifier column value for this IncrementalAppend element.

PARENT ELEMENTS

Click element to drill down for more information.

Table

CHILD ELEMENTS

Click element to drill down for more information.