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.

What differs when we choose the sorted input for aggregator transformation?

774

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

749

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

839

---

How can we delete duplicate rows from flat files?

939

---

Separate from an archive server and a powerhouse?

660

---

---

Which files are created during the session rums by informatics server?

901

---

What is exclusive and normal mode for repository services?

874

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1839

---

How many dimensions are there in informatica?

803

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5152

---

How do you handle two sessions in Informatica

852

---

how many types of dimensions are available in informatica?

730

---

What are the uses of etl tools?

825

---

explain one complex mapping with logic? sales project?

6381

---

Explain the difference between a data warehouse and a data mart?

779

---