Skip to Content
avatar image
Former Member

SCD without Table Comparison and History Pres Transform

Hello All,

We are in process of Migrating Legacy data to DW using BODS ,So i need to implements SCD2 in BODS.

My primary key in Target table is VARCHAR, So i am unable to use the Table Comparison and KEY_GEN Transform. Is there any other way to implement SCD2 without TC and

Date Increment in BODS.

Thanks

Vinay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 06, 2017 at 07:59 AM

    hi Vinay,

    You can implement SCD type 2 using joins or by lookup. But for generating surrogate keys you need an INT datatype column in target and key gen transfrom/ keygen function.

    Key_generation transform only allows int,real,double,float,decimal datatypes only.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2017 at 02:54 PM

    OK, Thanks Ravi for your prompt Reply.

    We are are in discussion with our Business mgmt to create INT column, If they agrees everything will be fine,

    If not i need to look for other ways.

    Regards

    Vinay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2017 at 08:48 PM

    Is there any workAround for key generation, my mgmt is not accepting to create new column

    Regards

    vinay

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 07:34 PM

    without TC, you can implement through Joins & Look-up.

    however if you want to have the surrogate key you definitely need to create a new column...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 10, 2017 at 08:34 PM

    Can I have the ATL file or dataflow steps to implement SCD2 without History preservation. As I trued to implement it but its not working.

    Add comment
    10|10000 characters needed characters exceeded