Runtime column propagation
You can define part of your schema to specify that extra columns be adopted and propagated through the rest of the job.
IBM DataStage uses Runtime column propagation (RCP) in situations where metadata isn't fully defined. When RCP is set, if your job encounters extra columns that are not defined in the metadata when it runs, it adopts these extra columns and propagates them through the rest of the job. This avoids errors due to missing mappings.
You cannot perform transformations on individual columns that were not explicitly defined in the DataStage flow. To transform a column, you must define it on the stage performing the transformation. Required columns must be defined on the stage that requires them. RCP propagates columns from source to target unchanged.
Runtime column propagation can be set in the Output tab for all connectors and stages.