Reputation: 45
I have a simple mapping with TPT as writer , Teradata Parallel Transporter throwing the following error?
Message: [ERROR] Type:(Teradata DBS Error), Error: (<Table> must be empty for Fast Loading.)
Upvotes: 0
Views: 902
Reputation: 184
It looks like you are using the LOAD operator of TPT which can only load an empty table. You will need to either a) delete all data from the table or b) use an operator that will allow you to INSERT/UPDATE to a table with data. You can read more about TPT operators here: TPT 14.10 Operators
Upvotes: 1