SCD - Slowly Changing Dimension





Vendor CodeVendor Name

1000

ABC Vendor

1000

DEF Vendor

1000

GHI Vendor



Vendor IDVendor CodeCurrent VendorVendor_status
1011000ABC Vendor0
1021000DEF Vendor1
1031000GHI Vendor2


Vendor IDVendor CodeCurrent VendorStart_DateEnd_Date
1011000ABC Vendor01/02/200605/25/2007
1021000DEF Vendor05/26/200701/04/2008
1031000GHI Vendor01/05/200812/31/3000


Vendor CodeCurrent VendorHistoric Vendor
1000GHI VendorDEF Vendor


Vendor CodeVendor NameVendor ActiveUpdated Date Time
1000ABC VendorN01/02/2006 09:14:15
1000DEF VendorN05/25/2007 15:32:05
1000GHI VendorY01/05/2008 10:02:25






Last Revised On: November 03, 2013

27290