Weekly Status 03-21-2014

1.spreadsheet process update:

1. work on non-dimensional tables with DWH source.

Updated Spreadsheet     OIR metadata combined.xlsx updated spreadsheet note: 03-21-14 Spread sheet table tracking

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. 
      

      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 column values  are set by other dimensional tables (which might be multiple leveled), and the latter tables has to be treated like the parent tables and 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.