Answer Posted / anand

OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high

OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP

explain in detail about type 3?

1022

---

Can you please send me the migration related issues .

2079

---

Explain what would you consider as your biggest achievement and why?

984

---

Explain the difference between detect alias and detect context?

1113

---

What is a bo repository?

1051

---

8. How much supervision have you typically received in your previous job?

2257

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2434

---

how to create metric universe ?

2355

---

how get the grand total in master-detail report?

2236

---

Can we create universe with no cache??

2516

---

Explain difference between zabo and webi?

1104

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3091

---

Difference between zabo and webi?

1116

---

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10408

---

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1957

---