Set and Multi Set Tables

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

Questions by parikshit18

Showing Answers 1 - 9 of 9 Answers

ielosta

  • Dec 4th, 2008
 

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions