I have a scenario where I can get bad records in my input file and I still want that the load should not fail while those bad records should be rejected it should log the rejected records with the reason somewhere. It is possible in some database like Vertica,
Can it be done in Teradata ? If yes pls explain.
very generic question - generic answer is yes where there will be always constrains.
For example does TPT update handle data type issues but still requires static number of columns...
You won't get a good answer if you don't get more specific.
For eg : I am trying to load a flat file of 10 records using TPT in teradata and records 3 and 5 have some problem like bad data or wrong number of columns . I want my load should not fail and load 8 records , rejecting 2 records(3 and 5). while the 2 records rejected should be log some where with the reason for rejection. How can this be handled.?