Table 6 :Contenu de la table Products_type2 après le premier rafraîchissement
productid_key | productid_app | productname | package | effective_date | to_date | discontinued |
1 | 101 | prod1 |
size= »1″>10 |
2002-02-12 13:50:48.000 | NULL | 0 |
2 | 102 | prod2 | 10 | 2002-02-12 13:50:48.000 | NULL | 1 |
3 | 103 | prod3 | 10 | 2002-02-12 13:50:48.000 | 2002-02-12 13:52:42.000 | 0 |
4 | 103 | prod3 | 20 | 2002-02-12 13:52:42.000 | NULL | 0 |
Table 7 :Contenu de la table Products_type3 après le premier rafraîchissement
productid_key | productid_app | productname | package | effective_date | package1 | effective_dat1 | package2 | effective_dat2 | discontinued |
1 | 101 | prod1 | 10 | 2002-02-12 13:50:48.000 | NULL | NULL | NULL | NULL | 0 |
2 | 102 | prod2 | 10 | 2002-02-12 13:50:48.000 | NULL | NULL | NULL | NULL | 1 |
3 | 103 | prod3 | 20 | 2002-02-12 13:52:42.000 | 10 | 2002-02-12 13:50:48.000 | NULL | NULL | 0 |