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

What is the use of tabular model, tabular sql, tabular reference in real time application?

961

---

What are the reasons to use a chameleon method in data warehousing?

1057

---

How to drill through from a powerplay cube to reportnet?

939

---

Describe the differences between a data warehouse and data mart.

1001

---

In document how to create metrics?

992

---

Explain piconet?

963

---

What are the difference between snow flake and star schema?

1006

---

What are components of reportnet?

1077

---

Which are the olap tools available that are supported by oracle?

935

---

What is a general purpose scheduling tool?

1115

---

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1973

---

What are the different methods of loading dimension tables?

995

---

Why is business intelligence (bi) important in data warehousing?

943

---

What is meta data and system catalog?

2303

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2130

---