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
- 7730 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
Explain teradata architecture?
Explain the term 'primary key' related to relational database management system?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the updated features of teradata?
Which is faster fastload or multiload?
What is teradata and why it is used?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
Syntax for case when statement?
Why managing the data is important?
What is node? How many nodes and amps used in your previous project?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Highlight all the modes that are present under Confidence Level.
What is the use of stored procedures in teradata?
Write a program to show the parser component used in teradata?
