Archives of the TeradataForum
Message Posted: Tue, 11 Sep 2007 @ 18:25:18 GMT
I have heard from different people different things but wanted to know what this forum thinks about the topic.
MULTISET and SET Tables. I know MULTISET does not do duplicate row checking and hence loads to it would be faster but there is an obvious risk.
PKs - A lot of warehouses do not enforce PKs. What are your thoughts about this?
I am a big believer in SET Tables and enforcing PKs. What is everybody else's thoughts about these?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|