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 degenerate dimension table?

1101

---

Explain what is the difference between powerplay transformer and power play reports?

1225

---

What is Active Datawarehousing?

1055

---

Explain what are conformed dimensions?

1143

---

What are the different types of join operations?

1050

---

What is data analysis?

1001

---

What is incremintal loading?

1188

---

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1110

---

What are modeling tools available in the market?

1021

---

What is the difference between a primary and secondary actor in use case modeling?

1126

---

What is dimensional modelling?

1035

---

How to design file watch jobs?

1019

---

What a static and local variable?

1134

---

what are the all possible features supported modify stage?

2223

---

What are different deliverables according to phases?

3470

---