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
- 8028 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
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the basic syntax for teradata select statement?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
In general, how do you optimze any sql in teradata?
Difference between stored procedure and macro?
What is the command in bteq to check for session settings ?
Explain the term 'row' related to relational database management system?
What do you mean by parsing?
What is the purpose of upsert command?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How is MLOAD Client System restarted after execution?
How can you track login parameters of users in teradata?
In BTEQ, how are the session-mode parameters being set?
What are differences between teradata and ansi session modes in teradata?
Steps to create a data model?
