Recently I came to know below feature of Merge.
LOGGING ALL ERRORS WITH NO LIMIT
But I found after the error table created the show Select * of error table is not referring the base table. And also I cannot drop the base table before dropping the error table.
Is there any way where one can find what is the error table created for a base table?
Also what will be the effect of logging errors with limit? Is there any document that can provide more knowledge about this feature?
dbc.ErrorTblsV tracks existing error tables.
And when you read the manuals you'll find all details:
The SQL DML manual for MERGE and the SQL DDL manuals for CREATE ERROR TABLE.
As a customer you might also have access to the Teradata 12.0 SQL Bulk Loading Complex Error Handling User’s Guide Orange Book.