Answer Posted / ramesh

what is junk dimension? Give an example

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.

How will the document be delivered to me?

1020

---

What is a stored procedure transformation?

993

---

wat are deployement groups in informatica, how it will be used for developers

1670

---

What is Session and Batches?

1042

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2065

---

Reusable transformation and shortcut differences

1782

---

What is a difference between complete, stop and abort?

1034

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2393

---

What is sorter transformation?

980

---

What is intricate mapping?

1096

---

What is dimensional table? Explain the different dimensions.

1114

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1223

---

How to update or delete the rows in a target, which do not have key fields?

1121

---

permutations of mapplet

2457

---

can u give example for factless fact table

6447

---