Archives of the TeradataForum

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

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

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>>