Archives of the TeradataForum
Message Posted: Wed, 13 Sep 2006 @ 16:04:51 GMT
| Subj: || || DIrty Reads and Multiload locks |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, September 08, 2006 05:15 -->
We have restriction to provide uninterrupted data access to BI layer. We are planning to use mload for data load onto the underlying tables.
Dirty read views will be built on top of these tables and BI layer will access these views. Since Multiload holds lock at the table level, will
there be any issues with this approach, please provide inputs.