Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 16:52:40 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Regarding Date Format Problem: Failed conversion
 
From:   Dan Linstedt

It sounds like you have a SQL Query override in place, if that's the case, make absolutely certain that the ORDER of the fields listed in the select statement MATCH exactly, the order of the fields in the Source Qualifier, and further that all fields in the SQ (with the override) are connected downstream (to the next transformation).

Finally, make sure you've upgraded your ODBC connection.

By the way, 8.1.1 Informatica has some tremendous fixes in the area of connections to Teradata....


Cheers,

Dan Linstedt
CTO, www.MyersHolum.com



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