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
- 7802 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
In FLOAD, record command can be used to select records.
.RECORD 1 THRU 998;
In MLOAD, option in import command can be used to select records.
.IMPORT INFILE FILE1
FORMAT TEXT
FROM 1 THRU 998
LAYOUT FILEIN
APPLY INSERTS;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the maximum number of dml can be coded in a multiload script?
List out all forms of LOCKS that are available in Teradata.
What are the various indexes in teradata? How to use them?
What are normalization, first normal form, second normal form and third normal form?
How to load specific no.of records using bteq, or fastload,or multiload
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is meant by a dispatcher?
Is multi insert ansi standard?
what is sysdba and sysdbc ? which has high priority ?
What is spool space? Why do you get spool space errors?
What are the available join types in teradata?
what is object level locking ? where do appear this type of locking ?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How can we check the version of Teradata that we are using currently?
What are default access rights in teradata? What explicit right can be given to a user?
