Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Oct 2006 @ 17:07:05 GMT


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


Subj:   Re: Execution of multiple macro's inside a macro
 
From:   Dieter Noeth

What would you lke to see in parallel? Scans on the source table? Merge into the target tables?

If i run a similar macro, it looks like this:

     6) We do an all-AMPs RETRIEVE step from TERADATA_EDUCATION.employee...
     7) We execute the following steps in parallel.
          1) We do an all-AMPs MERGE into TERADATA_EDUCATION.T1 from Spool
             1 (Last Use).
          2) We do an all-AMPs RETRIEVE step from
             TERADATA_EDUCATION.employee ...
     8) We execute the following steps in parallel.
          1) We do an all-AMPs MERGE into TERADATA_EDUCATION.T2 from Spool
             2 (Last Use).
          2) We do an all-AMPs RETRIEVE step from
             TERADATA_EDUCATION.employee ...
     9) We do an all-AMPs MERGE into TERADATA_EDUCATION.T3 from Spool 3
        (Last Use).

Dieter



     
  <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