Page 1 of 1
Data Lineage in Job
Posted: Mon Jun 21, 2010 1:15 pm
by lpadrta
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.
Posted: Tue Jun 22, 2010 4:49 am
by antonyraj.deva
What exactly is the issue? Could you please elaborate a bit?
Data Lineage in Job through Transform Stage
Posted: Tue Jun 22, 2010 9:28 am
by lpadrta
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?
Posted: Tue Jun 22, 2010 3:32 pm
by eostic
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
Posted: Tue Jun 22, 2010 4:30 pm
by ray.wurlod
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.
Posted: Tue Jun 22, 2010 7:50 pm
by lpadrta
Thank you very much EO!
Ray you are on target, I'll put in a request to obtain the patch.
Posted: Wed Jun 23, 2010 6:09 am
by eostic
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