Answer Posted / nitin

Fact table :- It consists of foreign Keys and MEasures(Numeric values)

Dimension :- It provides descriptive information relating to the foreign key in a fact

Eg:- in employee table i have ename empid sal
in manager table i have mname mid and sal

so there are two dimension table
1--> emp table contains enmae eid(PK) sal
2--> Mgr table contains mname mid(PK) sal

Fact table contains
eid(FK) mid(FK) esal and msal

PLease correct me if i'm wrong

Explain the difference between oltp and olap?

1053

---

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

915

---

Explain what are slowly changing dimensions?

966

---

What are session timeout and application timeout?

961

---

Explain why denormalization is promoted in universe designing?

905

---

How do you define data block size?

981

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

873

---

How can you set the session management?

1049

---

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

888

---

Explain what is the difference between stop and abort?

979

---

Explain multivalued dependency?

923

---

How much data hold in one universe.

927

---

Explain why are oltp database designs not generally a good idea for a data warehouse?

972

---

Can a dimension table contain numeric values?

1002

---

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

854

---