Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 17 Jan 2004 @ 15:13:45 GMT


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


Subj:   Re: Does Informatica +really+ force MultiLoad worktables into the target database?
 
From:   Harold D Kleven

We use the same approach outlined by Michael. It's consistant with our technical architecture and we don't experience any problems or throughput issues but have to adjust for Informatica's practice of appending prefixes to the table names....limits you to about 24 character table names. We get over that by truncating the base view names in the intermediate loading database (affects about 5% of our table names). We examined Chris' approach but the ETL team didn't like the idea of having to edit the generated script every time it was generated (their problem description not mine because I'm not an ETL person!).



     
  <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