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.

ware house management system is used?

943

---

i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????

1921

---

What are aggregate tables and aggregate fact tables?

962

---

What are the possible data marts in retail sales?

929

---

Explain the difference between dw and bi?

964

---

Explain which are the olap tools available that are supported by oracle?

940

---

Explain vldb?

984

---

Is union transormation is active transformation?

918

---

What is the limit to the number of sources and targets you can have in a mapping?

1040

---

What is pre-emptive and non-pre-emptive?

913

---

Where the cache files stored?

952

---

Explain normalization?

1046

---

How can we determine what records to extract?

1024

---

Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.

854

---

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

956

---