What is a surrogate key?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by Prachi

    The primary key used for the dimensional table is known as a surrogate key. It is also referred to as a genuine substitution for primary key utilizing the info sequence generator or other Oracle sequences. Also the SQL server identity values and acknowledge for surrogate keys.

Related Questions

Please Login or Register to leave a response.

Related Questions

Informatica Interview Questions

In warehouses how many schemas are there?

There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema..

Informatica Interview Questions

Could you explain what is Enterprise data warehouse?

In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

Informatica Interview Questions

What is different between the data warehouse and data mart?

A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales..