In FLOAD, record command can be used to select records. .RECORD 1 THRU 998

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

Question Posted / yuvaevergreen

4 Answers
8027 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

Please Help Members By Posting Answers For Below Questions

Highlight the advantages of PPI(Partition Primary Index).

1129

What is the purpose of upsert command?

1261

What are the functions performed by bynet?

1090

What is teradata and why it is used?

1183

Comment whether bottleneck is an error or not.

1223

What are the components provided on node?

1091

Explain amp in teradata?

1153

How to select first n records in teradata?

1162

Differentiate database data and data warehouse data?

1163

Explain and compare pros and cons of snow flake schemas?

1089

If a Node is busy what are the steps you can take to avoid ?

2458

What are the steps involved after the disk manager passes the request?

1184

What's the difference between timestamp (0) and timestamp (6)?

1257

What is a node in teradata? Explain

1053

Describe the set operators in teradata.

1050