Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 7731 Views
- I also Faced
- E-Mail Answers
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
Difference between inner join and outer join?
What is the purpose of joins in teradata and what are the available join types?
Mention a few of the ETL tools that come under Teradata.
Difference between multiload and tpump?
Explain the term 'columns' related to relational database management system?
What is the purpose of using case expression in teradata?
What is the use of stored procedures in teradata?
Highlight all the modes that are present under Confidence Level.
How can you track login parameters of users in teradata?
Where is teradata rdbms used?
What are teradata utilities?
What is collect statistics?
Highlight a few of the important components of Teradata?
What are the different functions performed in development phase?
Why does varchar occupy 2 extra bytes?
