Tag: set and multiset

Apr 21

SET or MULTISET tables

We know that in Teradata all the tables are either SET or MULTISET. The difference between SET and MULTISET tables is –  SET tables – SET tables did not allow duplicate values in the table. e.g. COLUMN 1          COLUMN 2          COLUMN 3          COLUMN 4 A                            b                            c                            d H                           g                            y                            k A             …

Continue reading