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
- 8020 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
How to find duplicates in a table?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What does Amp contain and what are all the operations that it performs?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by Teradata Gateway?
how many modules are there in telecome domain?how to explain the architecture?
What are the primary characteristics of the Teradata.
What is the opening step in basic teradata query script?
What happens when a node suffers a downfall?
How to identify ppi columns?
Why teradata is used?
Explain Teradata performance tuning and optimization?
What is database exceptions in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is stored procedure in teradata?
