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
- 7559 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
What are aggregate tables? How do you design them using teradata?
What's the difference between timestamp (0) and timestamp (6)?
What is the purpose of joins in teradata and what are the available join types?
any one answer me how they can analyzing the project using data ware housing?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is stored procedure in teradata?
Highlight the points of differences between the database and user in Teradata.
What is the difference between global temporary tables and volatile temporary tables?
Differentiate database data and data warehouse data?
What are the uses of bynets in multi-node systems?
How to Extract data from multiple legacy systems?
What are some commonly used bteq scripts?
What is meant by a Clique?
What is the purpose of upsert command?
What is database exceptions in teradata?
