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
- 7551 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
Mention a few of the ETL tools that come under Teradata.
How you will check the version of teradata?
What is basic teradata query language?
What does sleep function does in fast load?
What is meant by a Least Cost Plan?
What is collect statistics?
What is meant by a node?
What is the multi-insert?
How do you set the session mode parameters in bteq?
If a Node is busy what are the steps you can take to avoid ?
What are the functions of a Parser?
How to select first n records in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What do high confidence, low confidence and no confidence mean in explain plan?
What are tpump utility limitations?
