Answer Posted / deepthi

Few more additions to the above answers.....

Confirmed dimension: Dimesion which can be 100 % sharable
with other star schemas. In other terms it is connected to
more than one one fact table .

Ex: time dimension

Junk dimesion: stores low cordinality values (repeated
values),flagged values.
Ex: details of gender information(male/female)

Degenerated Dimension:The attribute in the fact table
directly comes from the source table not from any
dimensions called degenerated dimensions. these are also
called neither a dimension nor a perfect fact.

Ex:attribute order_no, comes from source

Slowly changing Dimensions:Dimesions which are changing
over a period of time called slowly changing dimensions.

Ex:salary of employee.

What is union transformation in informatica?

1136

---

How to go to the older version for a mapping?

1071

---

can u any challenge your project?

2020

---

What is the difference between a repository server and a powerhouse?

1492

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1118

---

Differentiate between sessions and batches?

1008

---

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

5651

---

Is there any way to read the ms excel datas directly into informatica?

1014

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1891

---

Enlist the various types of transformations.

1027

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2710

---

How to extract sap data using informatica?

1028

---

What are data-driven sessions?

1186

---

What is dynamic cache?

1021

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1888

---