Integration.Lineage - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Integration
Name	Lineage

Details of data load attempts

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		Lineage Key	int		Default: NEXT VALUE FOR [Sequences].[LineageKey]		DW key for lineage data
DW key for lineage data Default: NEXT VALUE FOR [Sequences].[LineageKey]
	2		Data Load Started	datetime2(7)				Time when the data load attempt began
Time when the data load attempt began
	3		Table Name	nvarchar(128)				Name of the table for this data load event
Name of the table for this data load event
	4		Data Load Completed	datetime2(7)				Time when the data load attempt completed (successfully or not)
Time when the data load attempt completed (successfully or not)
	5		Was Successful	bit				Was the attempt successful?
Was the attempt successful?
	6		Source System Cutoff Time	datetime2(7)				Time that rows from the source system were loaded up until
Time that rows from the source system were loaded up until

Unique keys

	Key name	Columns	Description
	PK_Integration_Lineage	Lineage Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59