Data Warehousing Community Forum
December 19, 2018, 10:17:43 pm

Pages: [1]   Go Down
  Print  
Author Topic: Need clariifcation on Row ID in Teradata  (Read 14770 times)
Ramakrishna
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 5


View Profile
« on: November 16, 2013, 11:46:47 pm »

HI All,

In Teradata tables, when the row insert into a table , the AMP stores the Row ID in-front of each on it's disk.

Does this ROW ID consumes storage of disk, If so is that be one of the challenge in Teradata?

Could you please explain?
Logged
advertisement
aliisajoseph
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile WWW
« Reply #1 on: November 18, 2016, 04:06:29 pm »

I also found that there is a difference on the identity column manipulation.... Thought we specified the start and end value along with increment count, it behaves differently. When we do Insert Into Values, it starts with 1 and incremented by 1 whereas when we do Insert Into ...Select, it starts with some 1000 or 10000 and incremented based on the increment value specified... don't know if there is any other dbc level setting for that.     
Tableau Training  |  Devops Training in Chennai  |  Informatica Training in Chennai Hadoop Training in ChennaiR Programming Training in Chennai
Logged

h  |   h  |   h  |   h  |   h
Pages: [1]   Go Up
  Print  
Jump to: