Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

1.spreadsheet process update:

    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

      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.




  • No labels