Answer Posted / prodyot sarkar

surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table.
Data warehouses typically use a surrogate (also known as artificial or identity key) key for the dimension tables primary keys. They can use Infa sequence generator or Oracle sequence or SQL Server Identity values for the surrogate key.
It is useful because the natural primary key (i.e. Customer Number in Customer table) can change and this makes updates more difficult.
Some tables have columns such as AIRPORT_NAME or CITY_NAME which are stated as the primary keys (according to the business users) but not only can these change indexing on a numerical value is probably better and you could consider creating a surrogate key called say AIRPORT_ID. This would be internal to the system and as far as the client is concerned you may display only the AIRPORT_NAME.

Explain difference between data ware house & data mart?

990

---

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

1039

---

What are the main steps to build the data warehouse?

1119

---

What is the difference between ods and oltp?

1019

---

Explain the versions of reportnet?

988

---

Explain me what is vldb?

933

---

What is the difference between junk dimension and degenerated dimension?

1136

---

Explain reference cursor?

2167

---

What is is a star schema?

1174

---

What are the various transformation available?

1012

---

Explain what is the difference between stop and abort?

1045

---

What are fact, dimension, and measure?

1335

---

Where do we use semi and non additive facts?

992

---

What is application.cfm?

1050

---

Why should you put your data warehouse on a different system than your oltp system?

976

---