SCD Stage-Compilation Error
Posted: Thu Sep 03, 2009 4:22 am
Hello all,
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,
I tried to map source and reference columns using
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
If I select Current Indicator option as the purpose code then I'm getting the following compilation error
Is there any way to implement this scenario with the help of SCD stage! Could you kindly suggest me.
Many Thanks & Kind Regards
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