I'm trying to implement SCD-Type 2 using SCD stage. (Version 8.1).
Details:
Source, Reference and lookup - DB2 tables
source table has only one key column CUST_ID, generated by DB2.
Reference table is not defined with any key column. But as per the business rule,
Code: Select all
If
SourceTable.CUST_ID=ReferenceTable.ACCUNT_ID
then Update row in fact table
Else
Insert row into fact table
SCD->Input tab-->Lookup tab
I have given the purpose code against CUST_ID--->ACCUNT_ID mapping as "Type 2". (Actually this is my current indicator column and key column as well)
I'm getting the compilation error
Code: Select all
"If at least one Type 2 column is present, then SCD stage requires either a Current Indicator column or an Expire Date column (or both) to be present in the dimension table!"
Code: Select all
"If there are no SCD type 2 columns then SCD Type 2 current indicator, effective date and expire date columns must not be present!"
Many Thanks & Kind Regards