DSXchange

I'm working on data validations using datastage. Prior to using DataStage for this, we had 3 primary tables that we extracted our data from and then we had a set of sql queries which we would run this data through. I'm just trying to think of the best way to do this with DataStage. I would like to b...

I think I am having issues because I am trying to join a table to another table after using the xml_input stage and the transformer for the my left table since I am extracting from an xml column. One thing I noticed was that I can't seem to select more than one key from the output columns on the xml...

Hello everyone. I'm trying to use the merge stage but am unable to get the data from the right table? What am I doing wrong? Any suggestions? Also, I'm not even sure if I can use the merge stage for 2 DB2 tables? Is the merge stage only for flat files? Do I have to use the join? The same thing was h...