Can any one explain about master data? and we use it frequently or rarely.

Multiset table with UPI will allow duplicates or not?

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.

Answer: No.

Improve Answer

What is the main difference between Primary Index and Primary key in teradata? and can we have this two on same column?

uday

• Oct 13th, 2014

Primary Index in Teradata is used for loading and extracting the data from Database. (TD will load data Through PI
) and other hand PK is cluster index uniqe identifier. Pk will not allow Null and duplicates but for PI ok

Agnes Melbin R

• Apr 11th, 2013

If i am not wrong , both the titles should be swapped from the above answer as follows , Primary Key --Always Unique --Does not allow NULL values --Optional for a table --Values cant be updated --Doe...

Answer Question  Select Best Answer