Answer Posted / nethaji

When a Fact table has dimension value stored it is called
degenerated dimension.Since a fact table doesn't store
textual items ,it should be stored in varchar datatype.
Why we are going?
Instead of maintaining a separate dimension table with
single values ,for eg.customer_policy_details='paid' ,we
can store it in fact table ,for performance.

How to get the first 100 rows from the flat file into the target?

1151

---

Explain piconet?

900

---

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

897

---

Explain where do we use semi and non additive facts?

960

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

870

---

What are the various transformation available?

958

---

Explain what is partitioning? What are the types of partitioning?

905

---

What is load manager?

985

---

How to know the time taken for particular report execution?

908

---

Explain grouped cross tab?

2568

---

Why null values are mapped as 0 in fact tables?

946

---

What are universe requirements?

964

---

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

899

---

Explain what is ods (operation data source)?

929

---

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1017

---