![]() |
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.
26 Apr 2016
| 2 comments
,
|
![]() |
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.
21 Apr 2015
| 9 comments
,
|
![]() |
Hi All,
20 Jan 2014
| 2 comments
,
|
![]() |
Hi All,
20 Jan 2014
| 4 comments
,
|
![]() |
Hi,
01 Nov 2013
| 2 comments
,
|
![]() |
Hi Folks
20 Dec 2012
| 7 comments
,
|
![]() |
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?
12 Sep 2012
| 3 comments
,
|
![]() |
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?
05 May 2010
| 2 comments
,
|