Answer / kkreddy

When we need more historical data we will opt for OLAP. And
when we need the real time data or current data we will opt
for OLTP.

Answer / mallikarjuna reddy

OLTPs are the original source of the data.OLAP data comes
from the various OLTP Databases

Answer / jay

If we need most recent updated data in reports we go for OLTP
or else we go for OLAP.

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  

---

Tell me about linked universe ?

5 Answers   Tech Mahindra,

---

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

WHAT IS ROW LEVEL SECURITY IN BO?

7 Answers   Wipro,

---

Explain what three things do you consider to be the most important factors for a manager?

1 Answers  

---

how can we build one report from two data bases

4 Answers   IBM,

---

How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  

---

WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,

---

WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,

---

If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,

---

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1 Answers  

---

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers   Wipro,

---