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 |
Explain how spool space is used.
How a Referential integrity is handled in Teradata?
Explain the advantages of partitioned primary index in a query?
What are two examples of an OLTP environment?
What are the various etl tools in the market?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
How do you Generate sequence at the time of Display?
What is meant by a Least Cost Plan?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
How will you solve the problem that occurs during update?
Explain the types of join supports by teradata?