This week:

Store Procedure dumps:
1. 1. dbDWH_script_20140224.sql
  2. dbLoadDWH_script_20140224.sql
Spread sheet update
1. 1. OIR metadata combined.xlsx
lessons and issues and process :
1. 1. SOME Tables not found in SP dump.
  2. can't locate insert / uodate statement sometimes.
  3. SOME Tables has columns extracted from multiple tables.
  4. stop searching after identifying the non-dimensional table source.
  5. no need to record sid (identity columns).
  6. need to check OIR database to locate origin of the database or the column definition.
  7. scan backward up the row to check errors and make correction when necessary.

Update Status:

processed tables:

TB_Dim_CalifResidency

TB_Dim_College_Enrollment

TB_Dim_ClassStanding

TB_Dim_CollegeDepartment

TB_Dim_College

TB_Dim_ClassStanding

TB_Dim_AmericanHistory

TB_Dim_AmericanInstitutions

TB_Dim_Course_MeetingTime

Course_MeetingTimeEnd

Course_MeetingTimeStart

TB_Dim_CollegeDepartmentCourse

TB_Dim_Course_MeetingDay

TB_Dim_CollegeDepartmentCourseClassType

table not yet processed

TB_Dim_CIP
TB_Dim_ClassStanding
TB_Dim_ActiveStudentFlag	can't locate insert /update
TB_Dim_AcademicOrProfessional	can't locate insert /update
TB_Dim_Student_NewFlag_SQL	not found in SP dump
TB_Dim_Time_Acad_Bridge	can't locate insert /update
TB_Dim_AcademicOrProfessional	can't locate insert /update