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 an aggregator transformation?

1102

---

How to load data in informatica ?

1028

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2017

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1498

---

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

1909

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1046

---

Briefly define a session task?

1140

---

What is blocking transformation?

1152

---

Explain informatica architecture - version 8 / 9

1099

---

How do you update the records with or without using update strategy?

1121

---

What is a mapplet/worklet in informatica?

1192

---

What is the function of union transformation?

1140

---

What is option by which we can run all the sessions in a batch simultaneously?

1149

---

What is a predefined event?

1097

---

What the difference is between a database, a data warehouse and a data mart?

1159

---