When developing a dimensional model, we often encounter miscellaneous flags

Tell me one example for junk dimension?

Question Posted / manoj

9 Answers
45914 Views
TCS, I also Faced
E-Mail Answers

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.

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of dimensional modeling?

1111

How can we schedule the graph in unix?

1041

What is the difference between view filter and report filter?

972

What is the purpose of cluster analysis in data warehousing?

1050

What is the difference between star and snowflake schemas?

1317

Explain about core dimension,

1036

What are the different types of join operations?

1050

How to test report in reportnet?

1054

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

997

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

992

What are the tools available for etl?

1026

in general which algorithms for used?

2074

Explain why fact table is in normal form?

1018

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2325

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

989