Answer Posted / anil panguluri

OLTP:
1- It is desined to support business transactional processing.
2- It is designed for running the business operations.
3- Volatile data.
4- Current data.
5- Normalised data.
6- Application oriented data.
7- 3-6 months of transaction history.
8- Desinged for clertical operation.

DSS:
1- It is designed to support desition making process.
2- It is designed for analying business operations.
3- Non volatile database.
4- Detailed data.
5- denormalised data.
6- Subject oriented data.
7- 5-20 years of transaction data.
8- Desinged for manageral access.
6-

What are partition points?

990

---

What is drilling across?

929

---

What are the steps of implementing data warehousing?

971

---

How can you communicate with web server (apache or iis) from coldfusion?

1029

---

How to create prompts in report net?

937

---

What is the differences between star and snowflake schemas?

982

---

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

2029

---

What are cluster analysis in data warehousing?

1049

---

What are modeling tools available in the market?

921

---

How do you setup Lo-cockpit?

3074

---

Explain the differences between normalizer and normalizer transformation?

949

---

Explain what is ods (operation data source)?

926

---

List any five applications of data warehouse.

885

---

What are the advantages of query studio compared to report studio?

838

---

What is defined as partial backup?

1017

---