none
no business key column is identified on existing dimension - Slow chg dimension

    Question

  • Hi,

    I m working to insert/update my Dimension table (in datamart) using SSIS "Kimball Method SCD component " tool.

    I have different columns as PK in source and identity column as PK in Dimension table.

    I also have Unique Index on the columns in dimension which are PK in source table yet I m getting error from the tool that "no business key column is identified on existing dimension"

    Any suggestions?

    Thanks,

    Thursday, February 20, 2014 8:43 PM

Answers

  • Business key needs to be defined in the component tool itself.

    Double click the component and it will open a wizard kind dialog box.

    The first tab is "Existing Dimension Input Column Definitions".

    In this tab, the grid has a column "SCD Column Type" which looks like label field but if you click it twice, it turns into dropdown list and from here, you can define Business key for your dimension table.

    HTH

    • Marked as answer by Me.Saqib Friday, February 21, 2014 6:06 AM
    Friday, February 21, 2014 6:06 AM