If those invalid records are the same everytime, then NULLIF option in DEF

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 / yogi

4 Answers
8026 Views
I also Faced
E-Mail Answers

Answer Posted / yogi

If those invalid records are the same everytime, then NULLIF
option in DEFINE command can be used(below). But, this would
not work, if the invalid values are different every time.

.DEFINE EMPLOYEE_NAME(CHAR(10),NULLIF='555555534'),
EMPLOYEE_ADD(CHAR(10),NULLIF=' ')
FILE=inputfile;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are normalization, first normal form, second normal form and third normal form?

1110

What is difference between user and database in teradata?

1117

What exactly do you know about catching in teradata?

1082

What is the difference between fastload and multiload? Which one is faster?

1299

Explain the term 'foreign key' related to relational database management system?

1119

What is basic teradata query language?

1164

What is collect statistics?

1051

what are the day to day activities of teradata DBA ?

5860

Describe the set operators in teradata.

1050

What is the multi-insert?

1084

How will you solve the problem that occurs during update?

1107

Where is teradata rdbms used?

1139

Describe primary index in teradata?

1053

Syntax for case when statement?

1118

How to view every column and the columns contained in indexes in teradata?

1100