Data Lineage in Job

lpadrta · Post by **lpadrta** » Mon Jun 21, 2010 1:15 pm

When I try to view data lineage in a DataStage parallel job, the lineage appears to stop at a stage variable that is used for some mapping activitiy. Is this how it works, or is there something I need to do differently? Thanks so much for your help.

antonyraj.deva · Post by **antonyraj.deva** » Tue Jun 22, 2010 4:49 am

What exactly is the issue? Could you please elaborate a bit?

lpadrta · Post by **lpadrta** » Tue Jun 22, 2010 9:28 am

I have a job with multiple steps, one of which is a Transform stage. In the Transform stage, I am using a Stage Variable to format a column, then mapping the Stage Variable to the output column.

When I go to the target stage, right click and select to trace where a column came from, the lineage diagrammed on the job canvas shows a link back to the Transform stage where the stage variable comes from, but does not continue the lineage back to the source stage.

With a little more looking, it looks like the lineage is only tracing back to the Transform stage even when I use a straight mapping from input to output without a Stage Variable involved.

Have you had a problem seeing the lineage in this situation?

eostic · Post by **eostic** » Tue Jun 22, 2010 3:32 pm

You are doing it correctly. The only time that lineage should stop at the column level is if the output column is derived from a Stage variable that doesn't use any input link cols.......if it does, then lineage should continue thru the Stage. There is apparently dual patch for this..one for DataStage and one for the Metadata Workbench. The workbench one is part of a patch for 8.1.2 and was released on June 14th and is available at the central patch site.....I'm not sure of the DataStage one at the moment, but will post a note if I find out.

Ernie

ray.wurlod · Post by **ray.wurlod** » Tue Jun 22, 2010 4:30 pm

Or you could take yourself to Fix Central and browse the available patches for your version and platform.

Save Ernie doing the work for you.

lpadrta · Post by **lpadrta** » Tue Jun 22, 2010 7:50 pm

Thank you very much EO!

Ray you are on target, I'll put in a request to obtain the patch.

eostic · Post by **eostic** » Wed Jun 23, 2010 6:09 am

I didn't find it at fix central, but maybe I missed it..... maybe it has to be requested specifically....anyway, I've been told that it's number if JR33537, if that helps. Let support qualify the requirement for you --- it's possible that the fix does other things also, or maybe it's rolled up somewhere....

Ernie

DSXchange

Data Lineage in Job

Data Lineage in Job

Data Lineage in Job through Transform Stage