1
Vote

Default nullability of the columns

description

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 dimension and look at TSQL create table script.
Expected behavior: AccountName column is not nullable
Observed behavior: Account name allows NULLs
 
<?xml version="1.0" encoding="utf-8"?>
<Vulcan xmlns="http://tempuri.org/vulcan2.xsd">
<Dimensions>
<Dimension ConnectionName="DataWarehouse" Name="DimAccount">
  <Columns>
    <Column Name="AccountID" Type="Int32" />
    <Column Name="AccountName" Type="WStr" Length="200" />
  </Columns>
  <Keys>
    <Identity Name="DimAccount_Identity" Clustered="true">
      <Columns>
        <Column ColumnName="AccountID" SortOrder="Asc" />
      </Columns>
    </Identity>
  </Keys>
  <Sources>
    <StaticSource Name="StaticSourceValues">
      <Rows>
        <Row>
          <ColumnValues>
            <ColumnValue ColumnName="AccountID" Value="1" />
            <ColumnValue ColumnName="AccountName" Value="'Unknown'" />
          </ColumnValues>
        </Row>  
      </Rows>
    </StaticSource>
  </Sources>
</Dimension>
</Dimensions>
 
</Vulcan>

comments