Answer Posted / kranthi.kunta

Degenerate dimension: A column of the key section of the
fact table that does not have the associated dimension
table but used for reporting and analysis, such column is
called degenerate dimension or line item dimension.
For ex, we have a fact table with customer_id, product_id,
branch_id, employee_id, bill_no, date in key section and
price, quantity, amount in measure section. In this fact
table, bill_no from key section is a single value, it has
no associated dimension table. Instead of cteating a
seperate dimension table for that single value, we can
include it in fact table to improve performance.
SO here the column, bill_no is a degenerate dimension or
line item dimension.

Explain conformed fact?

953

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1059

---

what are the others of "bad files" and "discard files" when using sql*loader?

2132

---

Explain the different types of data warehousing?

990

---

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?

1058

---

What is the purpose of Dataware Control?

1048

---

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1181

---

What are the key columns in Fact and dimension tables?

977

---

Where the applications and where ware house management system is used?

1012

---

What is the function of etl when used in data warehousing?

954

---

what is user variable in affinium campaign? and some real time examples.

4176

---

Explain what are the different methods of loading dimension tables?

953

---

What is the difference between agglomerative and divisive hierarchical clustering?

1184

---

What is the difference between Datawarehouse and OLAP?

923

---

What do you mean by static and local variable?

958

---