Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2009 @ 21:12:07 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Multiload SQL and Case statement
From:   Michael Larkins


You keep saying that they are "dropped." Have you tried exporting them from Error table 1? This would identify the ones that are not correct and you could either:

1. load these bad dates into your table - all with null or

2. load them into a staging table and then insert/select them from the staging table into the production table

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020