Interested to Buy Any Domain ? << Click Here >> for more details...
what are surrogate keys?
- 5 Answers
- 11676 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sai suresh
surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiva
surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deepthi pathuri
A surrogate key in a data warehouse is more than just a
substitute for a natural key.
(OR)
A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pradeep
surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.
| Is This Answer Correct ? | 0 Yes | 1 No |
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
What is the Hierarchy of DWH?
What is the exact difference b/w IN and EXIST in Oracle..?
How is Data Models Used in Practice?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Enlist the advantages of informatica.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
What is aggregate cache in aggregator transformation?
where does the default group roew in a router is stored what is the default size of memory in router
I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
What is the advantage of informatica?
Why do we need informatica?
Teradata 
