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 KEY_GEN Transform. Is there any other way to implement SCD2 without KG and Date Increment in BODS.
Regards
Vinay
vinay.sapds (BOB member since 2011-05-16)
Why do you assume that you cannot use Key generation with a varchar? Just add an additional query transform after the key gen and convert to a varchar.
If you mean that you require your keys to contain characters then you will need to write a custom function to do your key generation, either within DS or within your database. I would recommend at that point just using the key_gen function as a key to a lookup table that contains pre-generated alpha keys. Then have a daily job that adds new keys and deletes old ones to keep the table a reasonable size.
eepjr24 
(BOB member since 2005-09-16)