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

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1228

---

What is the difference between a connected look up and unconnected lookup?

1002

---

Whats there in global repository

1737

---

What is informatica powercenter repository?

1256

---

How can we create index after completion of load process?

1165

---

What do you mean by enterprise data warehousing?

1109

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7588

---

What is deployment group?

1296

---

What are the different ways to implement parallel processing in informatica?

1479

---

generate date / time dimension in informatica

1160

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7234

---

What is sq transformation?

1230

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2198

---

What are the types of lookup transformation?

1119

---

difference between informatica 8.1.1 and 8.6

3730

---