Vulcan 2.5 is not emitting foreign keys for <Dimension> or <TableReference> tags

Vulcan 2.5 is not emitting foreign keys for <Dimension> or <TableReference> tags

Id #4895 | Release: None | Updated: Feb 13 at 9:39 PM by yuriyt | Created: Sep 9, 2009 at 10:15 PM by yuriyt

Default nullability of the columns

It seems like default nullability of columns in Vulcan Version 2.5.0.29194 is set to IsNullable="yes" while previous behavior it used to be IsNullable="false"   Repro - compile the following dimens...

Id #4893 | Release: None | Updated: Feb 13 at 9:39 PM by yuriyt | Created: Sep 9, 2009 at 7:55 PM by yuriyt

Add 'WITH (TABLOCK)' for merge target table

To reduce resources consuming for key locks, especially when inserting BLOB objects.

Id #4883 | Release: None | Updated: Feb 13 at 9:39 PM by AaronZ | Created: Sep 7, 2009 at 5:51 AM by AaronZ

ForeignKey keyword needs to be added into schema file.

According to Scott's suggestion, the grammar will look as below: <Dimension KeyName="...." WithCheck="...." >       <ColumnMappings>             <ColumnMapping OutputName="...." />       </ColumnMa...

Id #4324 | Release: Vulcan 2.5 | Updated: Feb 13 at 9:39 PM by cgu | Created: Jun 24, 2009 at 9:37 PM by cgu

clustered attribute is missing in PrimaryKey

Id #4120 | Release: Vulcan 2.5 | Updated: Jun 5, 2009 at 9:00 PM by cgu | Created: Jun 5, 2009 at 9:00 PM by cgu

Error occurs when executing DetegoSchema package

Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started:  5:05:45 PM Progress: 2009-05-18 17:05:45.79  ...

Id #4068 | Release: None | Updated: Feb 13 at 9:39 PM by cgu | Created: May 19, 2009 at 12:06 AM by cgu

PackageConfigurations in Vulcan 2.0 exist in multiple configuration files

PackageConfigurations in Vulcan 2.0 exist in multiple configuration files and makes it very difficult to know which ones are still in use. Could this be replaced with an environment or phase varia...

Id #4034 | Release: Vulcan 2.5 | Updated: Feb 13 at 9:39 PM by vsabella | Created: May 7, 2009 at 3:49 AM by vsabella

ForeignKey and its test are missing in V2.5

Id #3984 | Release: Vulcan 2.5 | Updated: Jul 9, 2009 at 11:29 PM by vsabella | Created: Apr 13, 2009 at 9:54 PM by cgu

Add <PackageConfiguration> to load variables from config file

Since datawarehouse name may be changed due to operational reason, we won't use hardcoded database name in the development. In some code, the database name is embedded in complex long SQL statement...

Id #3953 | Release: None | Updated: Feb 13 at 9:39 PM by vsabella | Created: Mar 25, 2009 at 11:59 AM by zyzeng

FK naming issue

Hi Chao,   There’s a FK naming issue could you fix it in Vulcan 2?   $/Detego/Production-SQL08Upgrade/FactTables/XML/FactClarifyCaseOwnerHistory.xml <Dimension DimensionName="DimClarifyCaseOwnershi...

Id #3910 | Release: None | Updated: Feb 13 at 9:39 PM by vsabella | Created: Mar 11, 2009 at 12:07 AM by cgu