Answer Posted / manoj

When developing a dimensional model, we often encounter miscellaneous flags and indicators. These flags do not logically belong to the core dimension tables.

A junk dimension is grouping of low cardinality flags and indicators. This junk dimension helps in avoiding cluttered design of data warehouse. Provides an easy way to access the dimensions from a single point of entry and improves the performance of sql queries.

Example: For example, assume that there are two dimension tables (gender and marital status). The data of these two tables are shown below:

Code:
Table: Gender
Id Gender_status
----------------
1 Male
2 Female

Table: Marital Status
Id Marital_Status
----------------
1 Single
2 Married
Here both the dimensions have low cardinality flags. This will cause maintenance of two tables and decrease performance of sql queries.

We can combine these two dimensions into a single table by cross joining and can maintain a single dimension table. The result of cross join is shown below:

Code:
id gender mrg_status
--------------------
1 Male Single
2 Male Married
3 Female Single
4 Female Married

This new dimension table is called a junk dimension. This will improve the manageability and improves the sql queries performance.

What are the tools available for etl?

927

---

What are the different types of data warehouses?

1017

---

Explain what are the basic needs to join two sources in a source qualifier?

1018

---

What are the advantages of raid 1, 1/0, and

908

---

Explain which columns go to the fact table and which columns go the dimension table?

869

---

What is the purpose of Dataware Control?

990

---

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1008

---

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

928

---

How to reduce warnings?

901

---

What is metadata in context of a datawarehouse?

969

---

What are the reasons to use a chameleon method in data warehousing?

1000

---

What is the use of dimensional modeling in data warehousing?

920

---

Why fact table is in a normal form?

933

---

What are universe requirements?

964

---

What is Cognos script editor?

2482

---