Employees working in IT organizations are assigned different projects for a specific duration, such as a few months or years. The duration is specified by the project start date and end date in the database. The project location is different for each project, so employee location changes with change in project. A sample data for storage in database is provided below:

How is this an example of slowly changing dimension? Demonstrate three ways (type1, type2, and type3) to handle the dimension as discussed in the chapter using the example provided.

Transcribed Image Text:

Employee ID E101 E101 Project Code P101 P102 StartDate 05/11/2012 04/05/2014 Location EndDate ID 03/05/2014 L101 07/07/2015 L103