data lineage for custom OBIA 7964

User538247

Hi,

How to generate data lineage document for custom mappings & extension in OBIA 7964?

thanks in advance,

Thomas Dodds

basically you have to export/report all of your ETL, DW schema, RPD and Web catalog.  Optionally, you could load these into a database set of tables and build an OBIEE model on it.  The upgraded versions of OBIA 11g have the ODI ETL built in and it has the scenarios to also read in the exported RPD and webcat details.  If you are going to expend the effort ... do it on the whole -- hopefully you followed the Oracle recommended way to customize and extend - if so these are easy to pick out from the larger set.

User538247

Its OBIA 7964 with customisation , how to export ETL to excel? we do not have metadata manager plugin to export infa mapping data lineage... any other way to export data lineage to excel.

currently just need ETL data lineage...RPD & web catalog is not required.

Thomas Dodds

How to export workflows and mappings in informatica through unix shell script? - Toolbox for IT Groups

User538247

this process exports in xml & i want output in excel

Thomas Dodds

you can import XML data into excel ...