 |
 |
Archives of the TeradataForum
Message Posted: Mon, 14 Sep 2009 @ 11:39:32 GMT
| Subj: | | Re: Table/ row locking |
| |
| From: | | tony ng |
DWellman wrote:
| | One possible alternative may be to load all transaction data into a separate work table and apply using merge/update logic. There will
still be locking but it will be easier for you to manage from a restart/recovery perspective (the DBMS does most of the work for you). | |
Dave,
thanks for your help.
I think I will use seperate Work tables and then merge them into one FACT table.
cheers
tony
| |
