Answer Posted / sandeep.t nizamabad

1.oltp stands for online transaction process
2.transactions will be done in this process
3.this should be use by clerical users
4.IT CONTAINS ONLY CURRENT DATA
5.WE CAN STORE THE DATA UPTO ONE YEAR
6.THE DATA TYPE IS VOLATILE
7.IT CONTAINS THE DETAILED DATA
8.ROUTINE ACTIVITIES ARE IMPLEMENTED
9.ONE RECORD ONLY PROCESSED AT A TIME
10.INSERT,UPDATE,DELETE OPERATIONS ARE USED

What is the difference between dependent data warehouse and independent data warehouse?

939

---

What are the other names given to data warehousing?

1036

---

Explain about core dimension,

921

---

Explain er diagram?

934

---

Explain me what are conformed dimensions?

950

---

Explain difference between e-r modeling and dimentional modeling?

917

---

What is a relationship?

924

---

What is load manager?

984

---

How much data hold in one universe.

927

---

Explain can a dimension table contains numeric values?

920

---

Explain what is a cube in data warehousing concept?

930

---

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

932

---

Can we have multiple application.cfm file in an application?

906

---

Could any one explain me how to create cascading prompts?

987

---

How many project sources we can create in metadata?

1010

---