Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 25 Jul 2009 @ 09:15:03 GMT


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


Subj:   GTT-.export
 
From:   Rahul Shashidhar Phadnis

Hi,

We have around 50 sqls (db is Teradata) which are run and then this data needs to be inserted in the target. There is just one target table (also Teradata). Right now the procedures are run one by one.

We plan to do concurrent runs now. We are planning to have procedures/macros insert into GTT from each of the sessions and then do a .export before the session end & then finally load it into the target table.ETL used is Informatica. In Teradata Simultaneous inserts into single table is also not possible.

Can I do an export of GTTs ?

Any other approaches ?We cannot create 50 new permanent tables.


thanks,

Rahul



     
  <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