Interested to Buy Any Domain ? << Click Here >> for more details...
what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
- 2 Answers
- 8283 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh s. chandan
Unique identitiy key is generated during data load process
(ETL) in the datawarehouse system is called as Surrogate
key.
It is mainly used to update slowing changing dimesion
attribute data and also it removes dependencies on key
originating in different data sources.
Primary key is uniquely identified each record in a table
with no null values.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What xml support does the sql server extend?
how can you attach more than 20 ldf files in sql server
Can group by and orderby be used together?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How does stuff differ from the replace function?
Differentiate between a local and a global temporary table?
How to how to convert numeric expression data types using the convert() function??
What are the different types of collation sensitivity?
Do you know what is a trace frag? Where do we use it?
What is a print index?
what is a join? : Sql server database administration
What is a rollup clause?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to convert a numeric expression from one data type to another?
How to write an inner join with the where clause in ms sql server?
