Answer Posted / mallika

We can connect two fact tables by using constellation
schema or galaxy schema.
we have 3 types of schemas

star
snowflake
constellation or galaxy

in star schema we have data redundancy.we do not normalize
dimension tables.
in snowflake we normalize dimension tables to reduce space
boyh star aand snowflake we use only one fact and many
dimesion tables.in some situations we have to use more than
one fact table then we use constellation.but its vary
rarely used

What is Operational Data Store?

1019

---

Explain what are the methodologies of data warehousing?

887

---

What are the data types present in bo? What happens if we implement view in the designer n report?

897

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1050

---

What are the design methods of data warehousing?

907

---

How do you create surrogate key using ab initio?

956

---

How to performance tune reports?

1071

---

Which columns go to the fact table and which columns go the dimension table?

933

---

What are the various file formats involved in reportnet?

931

---

What are templates in which way it is help full?

951

---

Explain datawarehousing?

1010

---

Why is chameleon method used in data warehouse?

1126

---

Give some difference between oltp and olap.

975

---

Explain multivalued dependency?

945

---

What is the differences between star and snowflake schemas?

1004

---