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 |
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
In BTEQ, how are the session-mode parameters being set?
What is meant by a node?
Different phases of multiload?
What are the available join types in teradata?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What is a level of granularity of a fact table?
What's the difference between timestamp (0) and timestamp (6)?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
Can we collect statistics on table level?