0 Replies Latest reply on Mar 22, 2018 11:12 AM by LPNO

    Get a textual representation of ODS mappings, process flows

    LPNO

      I inherited a productive BI-reporting environment. ETL Process has been realized on OWB 11. I need to understand the mapping and process flows. The only documentation of the Mapping flow is graphical in the the mapping flow editor of OWB. That's nice for little flow maps, but looking at this I feel overwhelmed...

      Process_Flow.jpg

       

       

      What I got so far is only this in EXCEL

      MappingList.jpg

      which is generated mainly by

       

      select substr(table_name,1,3) layer,  owner, table_name, sum(num_rows) num_of_row, decode(substr(table_name,1,3),'STG',1,'STG',2,'COR',3,'DIM',4,'FAC',5,99) sortkey 
      from dba_tables where owner like 'DWH_EAO%'  and nvl(num_rows,0) >0 
      and substr(table_name,1,3) in ('STG','STG','COR','DIM','FAC')
      group by  decode(substr(table_name,1,3),'STG',1,'STG',2,'COR',3,'DIM',4,'FAC',5,99), owner, table_name 
      order by sortkey,3 desc;
      

       

      I would like to document this huge railway map in a intended text list, to make it more manageable and understandable. Is there a way I can do this by some SQL-Query? Do I find such a structured text representation somewhere in a logfile or something?

       

      Are there other ways to extract a textual self-documention of an OWB project?

       

      Thanks for you help.

      LPNO