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 are differences between teradata and ansi session modes in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What type of indexing mechanism do we need to use for a typical data warehouse?
How do you determine the number of sessions?
Explain the parallel data extension in teradata?
In Teradata, what is the significance of UPSERT command?
What are the string manipulation operators and functions associated with teradata?
What is the syntax for case when statement?
What is the use of fallback?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the functions of a teradata dba?
In BTEQ, how are the session-mode parameters being set?
What is the difference between fastload and multiload? Which one is faster?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Define views in teradata with syntax.