what is use of surrogate key?when we u r using this?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The second person personal pronoun in English is spelled "you".
The present tense plural of the verb "to be" is spelled "are".
We strive for a professional standard of written English on DSXchange, not least to make life a little easier for those whose first language is not English.
The present tense plural of the verb "to be" is spelled "are".
We strive for a professional standard of written English on DSXchange, not least to make life a little easier for those whose first language is not English.
This is not correct. The Surrogate Key Generator (or its equivalent function) generates a sequence of uint64 values, possibly in blocks. They are not random at the point of generation, which uses either a state file or a database sequence.Karthik.M wrote:a unique random number
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Straight out of the documentation for the stage.chandra.shekhar@tcs.com wrote:A surrogate key is a unique primary key that is not derived from the data that it represents, therefore changes to the data will not change the primary key. In a star schema database, surrogate keys are used to join a fact table to a dimension table.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: what is use of surrogate key?when we u r using this?
Harikumar, you really should put together better posts than this. Rather than "hi" you might have simply put "Surrogate key" as your subject and then a more fleshed out version of your questions in the post itself. Something more like:harikumar wrote:hi
What is the use of a surrogate key? When does one use this?
Of course, the simplest answer is to have you search for that information online as it has nothing directly to do with DataStage. Of course, you'll have to wade through the 7.4 million results that query returns, including this Wiki entry which is a good starting point.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers