DSXchange

I have developed a job that takes input from .csv files and generate output in XML file. Now problem statement is that: if the joining condition of two files not satisfy then tags related to that files should not be a part of the output. (means dynamically we have to set the columns(tags of XML files) in transformer stage.)

do we have any options available in DataStage that we can filter or restrict columns as per the joining conditions?

Not easily in server jobs. If the number of different structural possibilities is small you might contemplate using a separate output from the Transformer stage for each.

Welcome aboard.