Archives of the TeradataForum
Message Posted: Sat, 25 Jul 2009 @ 09:15:03 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|