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
- 7742 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
In Teradata, what is the significance of UPSERT command?
What do you mean by teradata intellicloud?
What is meant by a Highest Cost Plan?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Can we collect statistics on multiple columns?
How many sessions of MAX is PE capable of handling at a particular time?
What is meant by a Clique?
What is a dimension table?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Different phases of multiload?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What interface is used to connect to windows based applications?
Why is the case expression used in teradata?
What is the purpose of using case expression in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
