Answer Posted / bhavemanali10

It is a dimension field in the fact table that doesn't have a corresponding dimension table. As a result - a degenerate dimension will use the field as key, name and its only attribute.
Degenerated dimension can be used to link back to the source as it is a natural key of the "parents" of the line items. It is used in reporting. Degenerate dimensions commonly occur when the fact table's grain is a single transaction. Although there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows.
e.g.In health care, degenerate dimensions can group the claims items related to a single hospital stay or an episode of care

How can we store previous session logs?

988

---

What are the differences between joiner transformation and source qualifier transformation?

1094

---

What are the new features of informatica 9.x developer?

899

---

Define mapping and session?

966

---

What is a sorter transformation?

1033

---

What is a joiner transformation?

936

---

What are the databases that informatica can connect to windows?

1000

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1891

---

What are the types of schemas we have in data warehouse.

892

---

Explain the features of connected and unconnected lookup.

872

---

Can we create a Integration service without a Repository service and vice versa?

1170

---

How are the sources and targets definitions imported in informatica designer?

1048

---

Whats there in global repository

1641

---

Separate from a database, an information bazaar, and an information stockroom?

1009

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1925

---