Answer Posted / rams

Independent Data Mart Dependent Data Mart
1) it won't have 1) it will share the common dimension
shared Dimension
2) perfect Data mart 2) it's a Enterprise DW

What are universe requirements?

1056

---

How many project sources we can create in metadata?

1099

---

What is informatica architecture?

1070

---

Explain the definition of normalized and denormalized view and what are the differences between them?

933

---

What is the limit to the number of sources and targets you can have in a mapping?

1113

---

What is drilling across?

1000

---

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

944

---

Explain what are the different types of join operations?

977

---

What are data modeling and data mining?

1096

---

What are partition points?

1085

---

What is a cube in data warehousing concept?

1087

---

How can you set the client management?

1024

---

Explain dimensional modelling?

987

---

What is the difference between view filter and report filter?

933

---

What is operational data store (ods)?

1025

---