Archives of the TeradataForum
Message Posted: Mon, 23 Apr 2007 @ 16:38:23 GMT
I copied (applying business logic) 800 Gig of data ( Appr 3 billion recs) from the Production Table to Temporary Work table. To facilitate faster load I created Work table as a MULTISET. Production table is SET table.
However per Business, the Production table is expected to be maintained as SET table. Now I'm required to completely load the transformed data from my work table to Production table, after deleting the Content of the Production Table.
Will there be any better approach to load the data back apart from INSERT/SELECT ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|