Answer Posted / hardeep

Hi Pooja

Thanks for reply but could u pls explain more what type of dimensions are called as monster dimensions... Properties of Monster Dimensions.

Hardeep

Explain the difference between a data warehouse and a data mart?

1056

---

Global and Local shortcuts. Advantages.

2034

---

What are the static cache and dynamic cache in informatica?

1192

---

Explain constraint based loading in informatica

1093

---

What is dimensional table? Explain the different dimensions.

1172

---

What are Dimensional table?

1055

---

Briefly explain the aggregator transformation?

1008

---

How does the aggregator transformation handle null values?

1149

---

Is there any target staging area in informatica not staging area

2578

---

What is informatica worklet?

1067

---

Explain sessions and how many types of sessions are there?

1009

---

What is a surrogate key?

1080

---

How to do the error handling of if ur source is flatfiles?

1968

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1674

---

Explain why we use partitioning the session in informatica?

1092

---