Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Jan 2004 @ 12:33:42 GMT


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


Subj:   Multiload ET Table - HostData column
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, January 21, 2004 07:04 -->

Hi,

We use Informatica ETL to multiload a table from an oracle table, after few transformation steps....

We got few rows resulting in ET table due to a bad character in one of the fields (decimal field, but getting char data - Error code -2679). We know the sourceseq..

1. How do we find the record which caused this problem, with the help of this sourceseq ?. Had it been a normal flat file multiloaded, then we can easily open the file.. skip the records until we find the sourceseq to get it. But how do we go about in case of ETL doing some transformation and then loading ?

2. The Hostdata column has the record which caused this problem. But we are unable to decipher it (may be in hexa form..). How do we decipher it?


Thanks



     
  <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: 27 Dec 2016