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?
Dynamic XML
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Welcome aboard.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.