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
- 8016 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 are the various indexes in teradata? How to use them? Why are they preferred?
In Teradata, what is the significance of UPSERT command?
What are the multiload utility limitations?
Explain vproc in teradata?
Comment whether bottleneck is an error or not.
What are aggregate tables? How do you design them using teradata?
Can we collect statistics on multiple columns?
What are some commonly used bteq scripts?
What happens when a node suffers a downfall?
What is stored procedure in teradata?
How you will check the version of teradata?
How can you track login parameters of users in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the things to be considered while creating secondary index?
What are the different softwares used with their functions in teradata?
