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
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 smp and mpp platforms?
How is the teradata different from oracle?
Difference between multiload and tpump?
If a Node is busy what are the steps you can take to avoid ?
How do you define Teradata?
What are the various indexes in teradata? Why are they preferred?
Mention a few of the ETL tools that come under Teradata.
What do you mean by caching in teradata?
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?
Differentiate primary key and partition key?
What are the advantages of teradata?
What are the uses of bynets in multi-node systems?
What is meant by a Clique?
Name the five phases that come under MultiLoad Utility.
any one answer me how they can analyzing the project using data ware housing?