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
- 7797 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
IF it is always the last two records, then use RECORD
option. Assuming 1000 records are present, use the below
option to avoid the last two records
RECORD THRU 998;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What type of indexing mechanism do we need to use for a typical data warehouse?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Difference between stored procedure and macro?
Highlight a few of the important components of Teradata?
What are the functions of a teradata dba?
What do high confidence, low confidence and no confidence mean in explain plan?
any one answer me how they can analyzing the project using data ware housing?
What do you mean by teradata intellicloud?
Explain the parallel data extension in teradata?
Where is teradata rdbms used?
What is the maximum number of dml can be coded in a multiload script?
Describe primary index in teradata. And what are the available primary index types?
What are some commonly used bteq scripts?
What are the design features involved in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
