Answer / Vaibhav Shrivastava

A Surrogate Key is a unique identifier used in a data warehouse to replace the natural keys of the source system. It is an arbitrary value, such as an integer, assigned to each record in a table to ensure uniqueness and avoid redundancy. Examples include auto-incrementing IDs or universally unique identifiers (UUIDs). For instance, in a customer table, a surrogate key might be a column named 'customer_id' that automatically assigns a unique number to each new customer.

What is up date strategy and what are th options for update strategy?

2 Answers  

---

Compare and contrast aggregates & indexes

1 Answers   IBM, TCS,

---

Explain what are the different methods of loading dimension tables?

1 Answers  

---

Can a dimension table contain numeric values?

1 Answers  

---

What is a ETL/ How does Oracle support the ETL process?

1 Answers  

---

What are different deliverables according to phases?

1 Answers  

---

What are different stages of ?Data mining??

1 Answers  

---

Explain what are the various reporting tools in the market?

1 Answers  

---

Explain can a dimension table contains numeric values?

1 Answers  

---

how to find unique records in informatica level

1 Answers   IBM,

---

Explain what are necessary tasks to install reportnet software?

1 Answers  

---

difference between bo 6.5 and bo xi r2

3 Answers   Accenture, Polaris,

---