I would like to “misuse” TX as an ETL tool by populating an Existing table with new rows.
All the logic necessary is processed using TX. The end table to be filled is an existing table and it's table structure can't be modified so I also need to omit the system control fields. I planned to use an incremental load table but getting errors that the table already exist when I deploy.
Not sure if we can use TX this way and someone already solved such a problem
Any help would be appreciated.
Best answer by LorenzoView original