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
- 7548 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 stored procedure and macro?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are the steps involved in the process flow of the sql statement through channel attached system?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain teradata vs. Redshift?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Describe the set operators in teradata.
Describe primary index in teradata. And what are the available primary index types?
how do you manage the production space. what are the proactive methods you can take ?
What is partitioned primary index (ppi)?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Write a program to show the parser component used in teradata?
Steps to create a data model?
