Teradata - Set and Multi Set Tables

GeekInterview.com > Interview Questions > Database > Teradata

Go To First | Previous Question | Next Question

Teradata | Question 24 of 27

Set and Multi Set Tables

What are set tables and multiset tables in Teradata?Explain with an appropriate example?

Total Answers and Comments: 3

Last Update: April 14, 2009 Asked by: parikshit18

Sponsored Links

Best Rated Answer

—

Submitted by: ielosta

1)      Set tables cannot accept duplicate at row level not Index or key level.

Exmaple of rows for set table:

R1 c2 c3 c4 .. cn
1    2   3 4 ... 9      Accepted
1    2   3 4 ... 9      Duplicate is Rejected
2    1   2 4 ... 9
3    2   4 4 ... 9
4    3   4 4 ... 9          2)      Musti set Tables can accept duplicate at row level not Index or key level.

Exmaple of rows for multi set table:

R1 c2 c3 c4 .. cn
1    2   3 4 ... 9
1    2   3 4 ... 9       Duplicate is Accepted 2    1   2 4 ... 9
3    2   4 4 ... 9        3    2   4 4 ... 9       Duplicate is Accepted

Cheer,

Imo

Above answer was rated as good by the following members:
sri789

December 04, 2008 15:57:18

ielosta

Member Since: August 2006 Contribution: 5

RE: Set and Multi Set Tables

1) Set tables cannot accept duplicate at row level not Index or key level.

Exmaple of rows for set table:

R1 c2 c3 c4 .. cn
1 2 3 4 ... 9 Accepted
1 2 3 4 ... 9 Duplicate is Rejected
2 1 2 4 ... 9
3 2 4 4 ... 9
4 3 4 4 ... 9 2) Musti set Tables can accept duplicate at row level not Index or key level.

Exmaple of rows for multi set table:

R1 c2 c3 c4 .. cn
1 2 3 4 ... 9
1 2 3 4 ... 9 Duplicate is Accepted 2 1 2 4 ... 9
3 2 4 4 ... 9 3 2 4 4 ... 9 Duplicate is Accepted

Cheer

Imo

Is this answer useful? Yes | No

1 0