Suppose i have data like
2009/12/31
555555534
' '
Generally last 2 records are wrong format it is going to
error table but i don't want load error table if any wrong
format in Date column Pass "NULL" how can we do it fast load
Answer Posted / tdguy
IF it is always the last two records, then use RECORD
option. Assuming 1000 records are present, use the below
option to avoid the last two records
RECORD THRU 998;
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What happens in a conflict? How do you handle that?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the commands to make a new table, change a table and remove a table in teradata?
What are the different table types that are supported by teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What are the different design perspectives used in teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Why are oltp database designs not generally a good idea for a data warehouse?
During the Display time, how is the sequence generated by Teradata?
What are the joins in teradata?
Highlight the differences between Primary Key and Primary Index.
What is the primary index in teradata?
Explain Teradata performance tuning and optimization?
Syntax for case when statement?
Explain the types of join supports by teradata?