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
- 7792 Views
- I also Faced
- E-Mail Answers
Answer Posted / yogi
If those invalid records are the same everytime, then NULLIF
option in DEFINE command can be used(below). But, this would
not work, if the invalid values are different every time.
.DEFINE EMPLOYEE_NAME(CHAR(10),NULLIF='555555534'),
EMPLOYEE_ADD(CHAR(10),NULLIF=' ')
FILE=inputfile;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different design perspectives used in teradata?
What are the multiload utility limitations?
How do you create tables? Exact syntax, and create profiles, users in teradata?
if collect stats but it show low confidence why?
What is spool space? Why do you get spool space errors?
What are the different functions included in the server software?
Explain some differences between mpp and smp?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Explain teradata utilities. What is multiload, fast load, tpump?
What is multi insert?
What are the available primary index types?
What is meant by a Channel Driver?
What are the functions involved in shared information architecture?
What does sleep function does in fast load?
Highlight a few of the important components of Teradata?
