DSXchange

Hi All,

We are using Datastage with Netezza Combination. We use Netezza Enterprise stage to load data in Netezza tables.
While loading data, Datastage creates external tables in between the process. These tables have names starting with 'NZORCH'. Even after the process finish successfully, DS do not clean up these tables. Is there an option to clear these tables post execution of DS job?

Thanks in Advance for any help on this issue!

Hi,
When you load NZ tables with Load Method = ET, then it creates External Tables which you have to clean manually. Please use Load Method - nzload and you will solve the issue.
M.

Thanks Mobashshar for the reply. We are using nzload in all our jobs. Still to give it a try, I changed the option to ET and it did not create any External table.

Can there be something else causing this issue?

Thanks Again!