Answer Posted / samir kumar sahoo

OLTP stands for OnLine Transaction Processing . It uses
database tables(Fact and Dimention tables) to enable
multidimentional viewing, analysis and querying of large
amount of data.

Explain what are conformed dimensions?

1141

---

What function should we use to display the value entered or selected by a user in response to a prompt?

1032

---

What are the main steps to build the data warehouse?

1160

---

What are steps we have to follow in designing the userfriendly universe?

1018

---

Explain what is analytical or analytic mean?

1053

---

How we are using this function?

1183

---

List down some of the real time data-warehousing tools?

1025

---

what are relationships?

1106

---

What is batch processing?

1073

---

How to create prompts in report net?

1036

---

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

974

---

Explain about core dimension,

1033

---

What is type 2 version dimension?

1017

---

How to add a number to a macro variable?

1044

---

if you use oracle sql*loader , how do you transform data with it during loading?

2138

---