DSXchange

hi,
how can we find data lineage , i mean is there any plug-in to find data lineage.

cheers;
vijay

If the metadata is defined and stored in the repository. Then you can see the lineage by doing a usage analysis on the metadata from the manager.

However, I learned that Information Server has much more powerful tool for data lineage.

Hi,
i think usage analysis just shows the interdependencies b/w 2 jobs . how can i find the impact of meta-data like if we eliminate one column or add a column, it should show the impact and lineage on the job.Do we have any plug-in stage for such analysis.

cheers;
vijay

If you loaded the table definition from the Repository into your job, or if you saved the table definition from your job into the Repository, then you can effect a Usage Analysis on that table definition. But that's an impact ("where used") analysis, not a lineage analysis.

You should undertake this BEFORE effecting metadata changes. Then effect the metadata changes and adjust all affected jobs as necessary.

There are no tools within DataStage versions earlier than 8.0 for performing lineage analysis.

Hi,
Thanks very much,can i find usage analysis of column or metadata.



cheers;
vijay

Columns, well, not directly, but if you select the saved table definition and do a Usage Analysis
Then you can see the references of its columns in jobs

Usage Analysis on table definition does report at the individual column level.