1.spreadsheet process update:

work on non-dimensional tables with DWH source.
Eliminate about 170 columns,there were 84 columns source not identified out of 949 total.

The main issues regarding locating the sources are

dimensional tables listed in the dump was not found in the store procedure dump.
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.
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.
Some columns are aggregate columns or computed column, and can only be decoded by reading the source codes in the dump.
As a result, some tables requires hours to decode and has to go through multiple passes.

Browser not supported