Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 17 Jun 2004 @ 19:57:38 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Looking for most efficient technique
From:   Anomy Anom

<-- Anonymously Posted: Thursday, June 17, 2004 15:53 -->

Our project team is dead set on using RI on one of our databases. Current process using a ETL tool involves bringing table dumps out of Teradata, creating a hash file, and then doing another insert back to Teradata. I have convinced them that this is a very poor design choice (actually made by Oracle ETL specialists).

I am now faced with several techniques to achieve the end result. Please help me choose the best one!

I need counts on # rows inserted, # rows deleted and # rows with RI failure.

1) turn off RI,create table, join insert, left join insert,drop table, rename table

2) write a stored procedure

3) Multiload or T-Pump job

4) ?

I am leaning toward a Multiload job, but am not sure how it will handle the RI failures. Also, will it give me the counts I am looking for?

Also, currently these are small tables with few updates/inserts but will continue to grow over time.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020