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 core dimension?

1031

---

Why should we use data ware housing and how can you extract data for analysis with example?

976

---

What is surrogate key? Where we use it?

975

---

How to limit the max no of rows retrieved in the report?

967

---

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

1083

---

Explain what is metadata reporter?

946

---

Explain what is partitioning? What are the types of partitioning?

947

---

what is user variable in affinium campaign? and some real time examples.

4151

---

Briefly state different between data ware house & data mart?

1034

---

What is informatica architecture?

1045

---

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

962

---

Explain er diagram?

979

---

Explain what is a cube in data warehousing concept?

966

---

What are the stages that are required in data warehousing?

934

---

Explain what are necessary tasks to install reportnet software?

898

---