What is surrogate key?

Answer Posted / ram

Surrogate keys are keys that are maintained within the data
warehouse instead of keys taken from source data systems.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create different types of templates?

510


Is there any default username & pwd for bo designer & supervisor?

566


What is aggregate fact table?

527


Explain the definition of normalized and denormalized view?

517


What function should we use to display the value entered or selected by a user in response to a prompt?

508






Explain in detail abt measure objects? And what is the use of it? How to create it?

542


How can you import tables from a database?

548


Describe the differences between a data warehouse and data mart.

504


Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

596


What is the difference between olap and oltp?

554


What are the different types of datawarehosuing?

557


What is MODEL is Data mining world?

2056


What is load manager?

563


Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

538


What is the difference between data warehouse and operational systems?

592