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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / guest
INDICATORS is a keyword related to how FastLoad
handlesnulls in the input file. It identifies columns with
nulls and uses abitmap at the beginning of each row to show
which fields containa null instead of data. When the
INDICATORS option is on,FastLoad looks at each bit to
identify the null column. TheINDICATORS option does not
work with VARTEXT
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tdguy
IF it is always the last two records, then use RECORD
option. Assuming 1000 records are present, use the below
option to avoid the last two records
RECORD THRU 998;
Is This Answer Correct ? | 2 Yes | 2 No |
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
What are the steps involved after the disk manager passes the request?
In your project what type of issues and errors you facing in Teradata
Explain the advantages of partitioned primary index in a query?
What is a level of granularity of a fact table?
What is the difference between fastload and multiload? Which one is faster?
How to view every column and the columns contained in indexes in teradata?
What is the opening step in basic teradata query script?
What is the basic syntax for teradata select statement?
how can i answer for question like teradat architecture in interveiw
where we can use the delimiter in mload? pls let me know