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.

Explain the different lookup methods used in informatica?

1090

---

What is workflow? What are the components of workflow manager?

1228

---

Why do you use Mapping Parameter and mapping variable?

1802

---

What is a node in Informatica?

1079

---

How to extract sap data using informatica? What is abap? What are idocs?

1246

---

Is it possible to revert a global repository to local one and why?

1128

---

What do you understand by SOA of Informatica?

1039

---

what is INFORMATICA TESTING process

2330

---

What is a connected transformation?

1177

---

What is parallel processing in informatica?

1782

---

What is informatica? Why do we need it?

1158

---

What is a joiner transformation?

1031

---

Explain the informatica workflow?

1119

---

How can we store previous session logs?

1132

---

During the running session, output files are created by informatica server. Enlist few of them.

1017

---