Answer Posted / alhad kulkarni

The question is Advantages and Disadvantages, not What is
Star or Snowflake.
Star Adv: Reduced Joins, Faster Query Operation.
Snow Adv: Distributed data, Easier to obtain fact-less data
e.g. Orders Shipped across one Quarter.

Star DisAdv: Bigger table sizes, Too many rows in Fact Table
Snow DisAdv: More number of joins, Slower Query operation,

What are the tuning techniques you applied during your last project

1969

---

Can u generate reports in Informatica?

1026

---

What do you mean by enterprise data warehousing?

1002

---

What is target designer and target load order?

1053

---

Is stop and abort are same in informatica?

949

---

Is it possible to revert a global repository to local one and why?

1026

---

What is resilience time?

1051

---

What is the use of transformation?

947

---

What is dimensional table?

1004

---

Explain joiner transformation in informatica

1077

---

What is workflow manager?

991

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1807

---

How many ways are there to create ports?

1236

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1042

---

What is an Integration service in Informatica?

1084

---