Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 18:07:09 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Alter table and RI
From:   Jim Downey

Kent and Narayan,

Thanks for your responses.

I was experimenting with some of the RI features when I posted the original question. We use our ETL process to validate RI.

I was experimenting on empty tables and small test systems using a code generator that created the DDL. Hence the alter table statements instead of inclusion in the original create. A production implementation would be either via a populated table or inserting into the revised table.

What has your experience been using DBMS driven RI? What type of overhead is incurred during loading? What else would one need to be aware of? What are the benefits?


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