Archives of the TeradataForum

Message Posted: Tue, 24 Nov 2009 @ 16:18:56 GMT

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

You can't. I believe the best you can do is insert into the empty staging table, do whatever quality checks you can at that point, then insert into the final table (which could be an insert into a single table or an insert into an empty version of the final table unioning the new and old data).

It's definitely an inferior process to simply exchanging the partition. I'd say that after data concurrency and autonomous transactions, partition exchange is the next Oracle feature I most miss. (Next would be that the OLAP windowing functions work only over number of rows rather than data ranges, and then the fact that in 5 years on Oracle, I never found a query generating incorrect results, but in the last three weeks I've written two where Teradata gets the wrong answer.)

Dave

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