Element Details: Incremental+Append
 Back


Available in: Logi Info Source code name: IncrementalAppend

Configures this data layer to retrieve new records from the source that do not exist in the data mart table.

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.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ID
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.
Source
UserDefined
(Required) A SQL statement that returns a set of records. Use tokens, such as @Request and @Session, inside of the SQL command to control the result set.
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.

DataLayer.CSV
DataLayer.Definition List
DataLayer.Excel
DataLayer.Google App 		DataLayer.Google Spreadsheet
DataLayer.LDAP
DataLayer.Plugin 		DataLayer.REST
DataLayer.SimpleDB
DataLayer.SP 		DataLayer.SQL
DataLayer.Twitter
DataLayer.Web Feed


CHILD ELEMENTS

Click element to drill down for more information.

DailySchedule.Append New Data MonthlySchedule.Append New Data WeeklySchedule.Append New Data


 Back to top


Chart Debug