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
- 7796 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
How do you do backup and recovery in teradata?
What is meant by a Virtual Disk?
What is the purpose of using case expression in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain parsing engine in teradata?
When tpump is used instead of multiload?
What are the updated features of teradata?
What is partitioned primary index (ppi)?
How many sessions of MAX is PE capable of handling at a particular time?
How can we check the version of Teradata that we are using currently?
Discuss the advantages of using partitioned primary index in a query?
Explain teradata architecture?
What do you mean by teradata intelliflex?
Highlight the differences between Primary Key and Primary Index.
