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
- 7725 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
In the Primary Index, what is the score of AMPs that are actively involved?
What is the difference between teradata and basic rdbms?
Why do you get spool space errors? How do trouble-shoot them?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How do you do backup and recovery in teradata?
What is spool space? Why do you get spool space errors?
What are the different methods ot loading a dimension table? A fact table etc?
List out some of the primary characteristics of teradata.
What are the various indexes in teradata?
What are the various reporting tools in the market?
Explain fastload in teradata?
How is the teradata different from oracle?
What are the components used in smp and massively parallel processing (mpp) machines?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Highlight the need for Performance Tuning.
