Archives of the TeradataForum

Message Posted: Wed, 04 Aug 2010 @ 14:18:00 GMT

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

<-- Anonymously Posted: Wednesday, 04 Aug 2010 09:59 AM -->

Flat files are picked up from source to be loaded into the staging area of Teradata.

Informatica feature 'Pushdown Optimization' is used for the view creations dynamically as coded in the ETL's (thousands in number).

Since view creations are DDL statements and these are many in number, this creates deadlocks on the DD tables (metadata in Teradata) and these deadlocks are often resulting in ETL job failures. Stringent SLA's cannot absorb neither the load failures nor the time taken in restarting the jobs without data corruption.

Recommended caveats like limiting the number of jobs, retrying after deadlock detection and creation of temporary views clash with the SLA's.

Any new work-arounds?

Appreciate help.

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