I have a transactional dataset which has a date field, my query is whether it is better to bring in the date field into the PI for the table i am using or leave it out. The PI is currently made up of a product unique identifier which is duplicated for each date related to the product.

Hello, In our EDW a table is defined with PI on a coumn and Primary key on two other columns . We are running into maintenance issues due to the PI and Primary key. Can someone sugest if this is a good modeling practice ? if yes is thre an alternate approach instead Primary key.  USI is not an option since USI also causig overhead.
 

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

Hi All,
I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI.
As per the current data, the table has a skew factor of 75%.
Therefore, I created an identical table, this time with PI consisting of Col_A, Col_B and Col_C, with Col_C again as PPI.

Hi,
We have a 3NF model implemented in Teradata and I have a table of the following format :
Surrogate Key              Cust Id       Cust Name    X1        X2        X3           X4            Effective Start Date            Effective End Date

Hi Folks 
I have 2 tables with same PI columns . Both are M-set tables but the target has a PPI on one of the columns.
I am doing an Ins - sel from non PPI to PPI table everything else being the same. The table PI has 5 cols of which the PPI is on the date column.

Hi,

      I have a general question, For the Same Value but with different data type, How the Hash value will be generated? Same or Different?

For EG:

INTEGER PI value 123 and VARCHAR PI Value 123, For both of this same Hash value will be generated or different Hash Value will be generated?

When creating tables in Teradata is there an advantage to placing the column(s) that will be used for the Primary Index at the top of the column list?