Archives of the TeradataForum

Message Posted: Tue, 25 Sep 2012 @ 09:42:42 GMT

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

Hi James,

In principle you have the same options in Teradata (and probably in any DBMS) and as usual there are a number of ways of achieving this.

1) Use ARC or FastExport to take your pre-load and post-load copy of the data.

2) Clone the table before the load and then again after the load.

3) Add a "load sequence number" or "load date" column to your table definition and then delete rows using that column if necessary.

There are probably others as well but that's a start.

Which one is best for you will depend on a number of factors, but size of the table is probably the major one.

- Does your Teradata system have enough spare disk space for three copies of the data (option #2)?

- How long does it take to take a copy (option#1)?

- Can you affect the table definition (option#3)?

- If the table is PPI'd and you are loading into new partitions can you copy just the affected partitions?

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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