Skip to Content
0

SCD without Table Comparison and History Pres Transform

Jan 06, 2017 at 02:39 AM

416

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Ravi kiran Pagidi Jan 06, 2017 at 07:59 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
vinay k Jan 06, 2017 at 02:54 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
vinay k Jan 06, 2017 at 08:48 PM
0

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

Regards

vinay

Share
10 |10000 characters needed characters left characters exceeded
Srinivas Gajawada Jan 09, 2017 at 07:34 PM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
SATYAJIT Patnaik Feb 10, 2017 at 08:34 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded