SCD - Slowly Changing Dimension
Vendor Code | Vendor Name |
1000 | ABC Vendor |
1000 | DEF Vendor |
1000 | GHI Vendor |
Vendor ID | Vendor Code | Current Vendor | Vendor_status |
101 | 1000 | ABC Vendor | 0 |
102 | 1000 | DEF Vendor | 1 |
103 | 1000 | GHI Vendor | 2 |
Vendor ID | Vendor Code | Current Vendor | Start_Date | End_Date |
101 | 1000 | ABC Vendor | 01/02/2006 | 05/25/2007 |
102 | 1000 | DEF Vendor | 05/26/2007 | 01/04/2008 |
103 | 1000 | GHI Vendor | 01/05/2008 | 12/31/3000 |
Vendor Code | Current Vendor | Historic Vendor |
1000 | GHI Vendor | DEF Vendor |
Vendor Code | Vendor Name | Vendor Active | Updated Date Time |
1000 | ABC Vendor | N | 01/02/2006 09:14:15 |
1000 | DEF Vendor | N | 05/25/2007 15:32:05 |
1000 | GHI Vendor | Y | 01/05/2008 10:02:25 |
Last Revised On: November 03, 2013
27290