What Is The Importance Of Surrogate Key In Data Warehousing?

1.	What Is The Importance Of Surrogate Key In Data Warehousing?
Answer» Surrogate KEY is a PRIMARY Key for a Dimension table. Most importance of USING it is it is independent of UNDERLYING database. i.e Surrogate Key is not affected by the changes GOING on with a database. Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.

Answer»

Surrogate KEY is a PRIMARY Key for a Dimension table. Most importance of USING it is it is independent of UNDERLYING database. i.e Surrogate Key is not affected by the changes GOING on with a database.

Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?

What Is The Importance Of Surrogate Key In Data Warehousing?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment