Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2002 @ 00:41:04 GMT
| Subj: || || Re: Insert data into table |
| From: || || John K. Wight |
Multiset tables are very useful in ETL processes in staging area when you are doing INSERT/SELECTs into empty tables whilst performing
transformations. Another way is to use Multiset tables, but apply a USI to the (logical) PK columns. Although there is the overhead of
keeping the updated USI, this is probably best when doing delta updates and NOT big INSERT/SELECTS. I've even put BIG tables into
production using Multiset and it works fine - BECAUSE I KNOW that my rows are unique from my ETL processes!