Archives of the TeradataForum
Message Posted: Wed, 25 Oct 2006 @ 17:07:05 GMT
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
|