Submitted Questions

  • Master data

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

  • MultiSet table with UPI

    Multiset table with UPI will allow duplicates or not?

    Star Read Best Answer

    Editorial / Best Answer

    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.

  • Diff Between Primary Index And Primary Key

    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...