Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Pushdown Optimization and DD deadlocks.
 
From:   Anomy.Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023