public static void ProcessLateArrivingTable(AstTableNode astTableNode) { var lateArrivedColumn = new AstTableColumnNode(astTableNode) { Name = "_LateArrived", IsNullable = true, ColumnType = ColumnType.DateTime2, IsAutoGenerated = true }; var markLateColumn = new AstTableColumnNode(astTableNode) { Name = "_IsLate", IsNullable = true, ColumnType = ColumnType.Boolean, IsAutoGenerated = true, Computed = "_LateArrived IS NOT NULL PERSISTED NOT NULL" }; astTableNode.Columns.Add(lateArrivedColumn); astTableNode.Columns.Add(markLateColumn); }
public static void ProcessTableScdColumns(AstTableNode astTableNode) { AstLowererValidation.ValidateScdTable(astTableNode); bool emitScdColumns = astTableNode.Columns.Any(column => column.ScdType == ScdType.Historical); if (emitScdColumns) { var scdFromColumn = new AstTableColumnNode(astTableNode) { Name = "_scdFrom", ColumnType = ColumnType.DateTime2, IsAutoGenerated = true }; astTableNode.Columns.Add(scdFromColumn); var scdToColumn = new AstTableColumnNode(astTableNode) { Name = "_scdTo", ColumnType = ColumnType.DateTime2, IsAutoGenerated = true }; astTableNode.Columns.Add(scdToColumn); } }
private static void ProcessTables(AstRootNode astRootNode) { var tables = new List<AstTableBaseNode>(astRootNode.Tables); foreach (var dimension in astRootNode.Dimensions) { tables.Add(dimension); } foreach (var fact in astRootNode.Facts) { tables.Add(fact); } foreach (AstTableNode table in tables) { if (table.LateArriving) { LateArrivingLowerer.ProcessLateArrivingTable(table); } if (table.HasScdColumns) { SlowlyChangingDimensionsLowerer.ProcessTableScdColumns(table); } foreach (var staticSourcePackage in StaticSourcesLowerer.ProcessTableStaticSource(table)) { astRootNode.Packages.Add(staticSourcePackage); } if (!(table is AstTableCloneNode) && table.EmitVersionNumber) { var versionNumber = new AstTableColumnNode(table) { Name = "VersionNumber", ColumnType = ColumnType.Binary, Length = 8, CustomType="rowversion", IsAssignable=false, IsNullable = false, IsAutoGenerated = true }; table.Columns.Add(versionNumber); } if (table.Emit) { astRootNode.Packages.Add(TableLowerer.ProcessTable(table)); } } }