Page Comparison

...

1. processed tables:

   TB_Dim_CIP

   TB_Dim_CIPSeries

   TB_Dim_CalifResidency

   TB_Dim_College_Enrollment

   TB_Dim_ClassStanding

   TB_Dim_College

   TB_Dim_CollegeDepartment

   TB_Dim_CollegeMajor

   TB_Dim_ClassStanding

   TB_Dim_AmericanHistory

   TB_Dim_AmericanInstitutions

   TB_Dim_Course_MeetingTime

   Course_MeetingTimeEnd

   Course_MeetingTimeStart

   TB_Dim_CollegeDepartmentCourse

   TB_Dim_CollegeDepartmentCourseSection

   TB_Dim_CollegeMajor

   TB_Dim_Course_MeetingDay

   TB_Dim_CollegeDepartmentCourseClassType

   TB_Dim_College_Enrollment

   TB_Dim_DegreeType

   TB_Dim_EnrollmentStatus

   TB_Dim_EntryLevelWriting

   TB_Dim_EthnicCodes2009

   TB_Dim_Gender

   TB_Dim_HomeLocation

   TB_Dim_LawStudentLevel

   TB_Dim_LawStudentTransfer

   TB_Dim_ProbationStatus

   TB_Dim_Program

   TB_Dim_School

   TB_Dim_SmrHomeUCCampus

   TB_Dim_Student

   TB_Dim_UCStudentStatus

   TB_Dim_Visa

   TB_Fct_CWE_00_Base_Acad_College_Dept_Course_Class_Level_Section_Class_Standing

   TB_Fct_CWE_00_Base_Acad_Dept_Course_Building_MeetingDay

   TB_Fct_CWE_01_Acad_College_Dept_Course_Class_Level_Section

   TB_Fct_Enrrollment_00_Base_College_Major_Student_Monthly_Enrolled

   TB_Fct_Enrrollment_00_Base_College_Major_Student_Monthly_Ext01

   TB_Fct_Enrrollment_01_College_Major_Monthly_Enrolled_Count_TYLY_Ext01

   TB_Fct_SOC_Enrrollment_10_Base_College_Major_Course_Student

   TB_Fct_SOC_Enrrollment_12_Base_College_Major_Course_Student_Monthly

   tblEOTSOCCourseMeetingData

2. table or columns with  source unfound:

   1. dimensional tables listed in the dump was not located in the store procedure dump.

   2. column sources not found:

      1. Some Dimensional tables There might involve many levels of stage tables (stg_ prefix up to 8 or more).

      2. It may need to trace back from level 08 back to 00, then the relational table can be located by reading the source code

      3. these columns cannot be located easily by searching for INSERT statements.

   3. Some columns column values are set byother by other dimensional tables (which might be multiple leveled) orand, these the latter tables has to be treated like parent tables and has to be decoded before the child tables.

   4. Some columns are aggregate columns or computed column, and can only be decoded by reading the source codes in the dump.

   5. As a result, some tables requires hours to decode and has to go through multiple passes.
      
      

...