Answer Posted / ravi sadanand

Star Schema: It is fully denormalized schema.the diagram of
fact table with dimension tables resembles a star that's
why it is called star schema.All the dimensions will be in
2nd normal form.
Snow flow schema:In this all dimensions will be in
normalized form.that's why it is called normalized star
schema.For each attribut a seperate table will be
created.As there is a possibility for more number of
joins,obviously the performance will be degraded.

How to delete duplicate row using informatica?

981

---

What are some examples of informatica etl programs?

884

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1984

---

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

1839

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2048

---

What do mean by local and global repository?

1150

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1048

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1030

---

What is joiner change?

1077

---

What is domain in terms of informatica?

951

---

What do you understand by a term domain?

1060

---

How do you handle two sessions in Informatica

1070

---

What happens when a session fails and you click on recover?

1054

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2019

---

What is rank transformation?

927

---