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,

server hot-ws270 is connect to Repository B. What does it mean?

2648

---

What is joiner transformation in informatica?

1098

---

How does a sorter cache works?

1109

---

How to call shell scripts from informatica?

1043

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289

---

What are multi-group transformations?

1162

---

Explain the features of connected and unconnected lookup.

973

---

State the differences between sql override and lookup override?

1283

---

What is an expression transformation in informatica?

1089

---

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?

1121

---

How can we use mapping variables in informatica?

1123

---

What is an aggregator transformation?

1142

---

What is a stored procedure transformation?

1112

---

Describe the impact of several join conditions and join order in a joiner transformation?

1113

---

Do you find any difficulty while working with flat files as source and target?

1146

---