I'm currently using a table input step that runs a sql to extract data. I have another text file input stream and I need the data from the table input step to replace one of the field values in the text file input. How would I go about doing that?
I've tried merge joins but it doesnt get me the result expected as it tends to lose some of the data.