data lineage

vijaykumar · Post by **vijaykumar** » Thu Nov 30, 2006 6:02 pm

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

cheers;
vijay

I_Server_Whale · Post by **I_Server_Whale** » Thu Nov 30, 2006 6:11 pm

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.

vijaykumar · Post by **vijaykumar** » Thu Nov 30, 2006 6:43 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 6:53 pm

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.

vijaykumar · Post by **vijaykumar** » Thu Nov 30, 2006 7:05 pm

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

cheers;
vijay

narasimha · Post by **narasimha** » Thu Nov 30, 2006 7:15 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Nov 30, 2006 9:41 pm

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