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.


Click attribute Name to drill down for more information.

NamePossible ValuesDescription
(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.
(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.
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.
(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.


Click element to drill down for more information.



Click element to drill down for more information.

 Back to top