Answer Posted / kick

Very nice page I must say.

Mainly Data warehouse has three type of schemas available.

1. Star Schema

2. Snow Flake Schema

3. Fact Constellation Schema or Galaxy Schema

It was really hard time for me to get to know exactly how this all schema works and what is the main differences between these schema.

I searched a lot on web and got one detailed answer in below link. May be this can also help you guys to understand.

http://www.aajsearch.com/142/what-are-the-different-schema-in-data-warehousing

How we can create indexes after completing the loan process?

1146

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1645

---

What is a sorter transformation?

1042

---

What are the advantages of informatica?

960

---

What is an unconnected transformation?

1035

---

How many ways a relational source definition can be updated and what are they?

956

---

what is the Default Source Option For Update Strategy Transformation?

1170

---

What are the new features of Power Center 5.0?

1702

---

How to start a workflow using pmcmd command?

1178

---

I have a flat file, want to reverse the contents of the flat file

1068

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10633

---

How to use pmcmd utility command?

972

---

How can we handle two sessions in informatica?

985

---

How might you approve all mappings in the archive all the while?

958

---

What is a repository manager?

1030

---