In a server job, I have a sequential file that feeds an ODBC stage. The ODBC stage uses the update action "Update existing rows only".
Since I am re-using this sequential file in a later process, I would like to have more input columns than are used in the update. (i.e. 5 columns in sequential file, only 4 get updated in ODBC stage.)
Is this possible? How do I set it up?
Need to ignore data elements in ODBC update
Moderators: chulett, rschirm, roy
Re: Need to ignore data elements in ODBC update
Read the extra column in the sequential stage but don't connect it to anything in the transformer.
Ogmios
Ogmios
In theory there's no difference between theory and practice. In practice there is.