Data warehousing with Teradata
Thursday, January 20, 2011
In case of NUSI, does AMP has local subtable?
Yes. In case of NUSI, AMP is going to have a subtable
which has only information for the rows in the same AMP.
But in case of USI, Each row in AMP is hashed and decide AMP number
to store its information in Secondary index Sub table
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment