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
- 7787 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 basic syntax for teradata select statement?
What is inner join and outer join?
What is bteq utility in teradata?
How do you determine the number of sessions?
what is sysdba and sysdbc ? which has high priority ?
Describe primary index in teradata. And what are the available primary index types?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the primary characteristics of the Teradata.
What are the different functions included in the server software?
What are teradata utilities?
Can you connect multiload from ab initio?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Difference between star and snowflake schemas?
What happens when a node suffers a downfall?
How to identify ppi columns?
