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
9794