Page Comparison

...

1. work on non-dimensional tables with DWH source.
1. Updated Spreadsheet : OIR metadata combined.xlsx
   1. updated spreadsheet note:Spread sheet table tracking 03-14-14
      a. See notes for tables or table columns with untraceable source

      1. The main issues regarding locating the sources are

         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 STG (stage tables 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. Some columns are referring to another dimensional tables (which might be multiple leveled) or, these tables has to be treated like parent tables and has to decoded before the child tables.

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