Hi all,
our customer has tables that are SCD2 historized with valid_from and valid_to columns and a “version” column, where 1 is the most recent entry, 2 the next older entry and so on.
Is there a possibility to load these tables into TimeXtender, preserve the history (make it useable for TimeXtender) and continue historizing in TimeXtender, so that they can turn off the historization in their source table?
Best answer by rory.smith
Hi,
you would need to essentially replay the history by loading all version one into the type 2 table, update all SCD From and To dates based off the raw source table, load version 2 from source into the table, update those changed records (all current records), etc. You also need to be sure you want history captured at reload moment vs. at change moment (which is likely what the source does).
I usually advise against this kind of thing, but I don't know any of the deeper context.
+7Hi,
you would need to essentially replay the history by loading all version one into the type 2 table, update all SCD From and To dates based off the raw source table, load version 2 from source into the table, update those changed records (all current records), etc. You also need to be sure you want history captured at reload moment vs. at change moment (which is likely what the source does).
I usually advise against this kind of thing, but I don't know any of the deeper context.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
