Explain if a flat file cotains 1000 records how can I get first and last records only?

945

---

Explain what is fact less fact table? Where you have used it in your project?

946

---

What does level of granularity of a fact table signify?

1117

---

What are the different methods of loading dimension tables?

1008

---

Explain what are the modules in power mart?

1066

---

Explain what is ods (operation data source)?

1005

---

Explain difference between data ware house & data mart?

998

---

Explain what is the difference between view filter and report filter?

995

---

What is data type of the surrogate key?

1018

---

Where the applications and where ware house management system is used?

1028

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

944

---

What is the difference between power center & power mart?

997

---

Explain what are conformed dimensions?

1104

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

976

---

How to calculate fact table granularity?

1036

---