Pass parameter value as column name

[hitmanthesilentassasin]

Hi,

Is it possible to pass a parameter instead of a column name so that the column value will be passed.

In transformer i need to map the columns dynamically. the column names will be passed as the job parameter and they could change when needed.

what could be alternative for this?

Thanks,
Hitman

[ray.wurlod]

Welcome aboard.

In DataStage the metadata drives the data, not the other way around. What you seek to do is not really possible.

Some people have experimented with using the Schema File property, and attempted to use a dynamic record schema, relying upon runtime column propagation to achieve pass-through of "all other columns", with varying degrees of success.