DataStage: Supported transformation details

IBM InfoSphere DataStage uses jobs with stages instead of transformations. DataStage has three job types: parallel jobs, sequence jobs and server jobs. For a list of all job stages per job type in DataStage, read the IBM documentation.

Indirect lineage

Collibra Data Lineage supports indirect lineage for PxLookup stages. Indirect lineage is created for fields that are used in the Lookup transformation but are not part of the transformation output.

For more information about indirect lineage, go to The technical lineage graph and Technical lineage Settings tab pane.

Supported parameters and expressions

Technical lineage for DataStage supports the following parameters and expressions:

File patterns in PxSequentialFile stages

When a PxSequentialFile stage uses the filepattern property, the value typically contains wildcards, such as *, that DataStage resolves at runtime against the file system. Because the DataStage integration does not have access to the file system, it cannot determine the actual files that match the pattern. As a result, Collibra Data Lineage cannot create file assets or generate lineage for these file sources.

To generate file asset lineage, use the file property with a concrete path or a parameter value that can be resolved during analysis.

For details about how Collibra Data Lineage extracts lineage and resolves parameters from DataStage, go to Transformation logic and common errors for DataStage.