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 tuning techniques you applied during your last project

2029

---

what is SDLC way of code development?

2046

---

What do you mean by blocking transformation?

1052

---

What is primary and backup node?

1137

---

Performance tuning in UNIX for informatica mappings?

2571

---

Could you explain what is enterprise data warehouse?

1150

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1131

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2013

---

What is a shortcut and copy in Informatica and how two are different with each other?

1201

---

Differences between connected and unconnected lookup?

1224

---

what is the size of u r source(like file or table)?

2275

---

What are session parameters ? How do you set them?

1856

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1073

---

Enlist the tasks for which source qualifier transformation is used.

1044

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2130

---