Author |
Message |
devika Forum Member


Joined: 11 Feb 2016
   Posts: 1

|
Posted: Thu Feb 11, 2016 1:43 am Post subject: SCD2 implementation |
|
|
Hi Experts,
I am new to BODS,I would like to know if SCD2 can be implemented in a dataflow without using History preserving transform.My TL says using History Preserving Transform in the dataflow will be a bottle neck when the source is having huge volumes of data.Any alternatives for History Preserving Transform.Please advise.
Thanks in advance |
|
Back to top |
|
 |
reddevilme Senior Member


Joined: 26 Aug 2013
      Posts: 37 Location: New Jersey

|
Posted: Wed Mar 02, 2016 1:39 pm Post subject: Re: SCD2 implementation |
|
|
What kind of volume are we talking about here?
There are ways to implement SCD2 without using History_Preserving transform but I am not sure if they would be as efficient.
Instead of using History_Preserving, you can make the updates from Table Comparison (or lookup if you do not plan to compare any columns) as inserts. You can use the same updates to expire the existing records in the target using the Pk/Surrogate Key that you get from TC. You might need to use Transaction control in such cases to avoid table locks. |
|
Back to top |
|
 |
eganjp Forum Addict


Joined: 12 Sep 2007
             Posts: 4280 Location: Denver Area

|
|
Back to top |
|
 |
|