historical data load from SQL to teradata temporal

2019-09-10 02:55发布

I need to do a historical type 2 data from a SQL server table to treat temporal table. I asked this question earlier but did not ask it completely and only 1st part was mentioned in question. below is link for same: Previous Question with Answer Sorry if I am duplicating question but that thread looks dead and I can use some help here. I need have three versions of data in SQL server Version 1,2,3. e.g.

Version 1 -
 Effective start date   Effective End Date
 1/1/10                  1/1/11
Version 2 - 
Effective start date    Effective End Date
1/1/11                   1/1/14
Version 3 - 
Effective start date    Effective End Date
 1/1/14                  12/31/9999

I am able to set period start and end time manually for version 1 but as version one is already expired so i am not able to add version 2 keeping version 1 also in teradata. If i try to do that it actually override version 1 itself and only latest version is present in teradata. Can someone please help. Thanks!

0条回答
登录 后发表回答