When we go for OLAP , and When we go for OLTP for
generating the reports ?

Answer Posted / mallikarjuna reddy

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain difference between zabo and webi?

656


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1557


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?

557


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

632






Explain is data mart?

595


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4323


What is the difference between the public object&schema object?

578


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1432


how many reports have u created ? explain a few.

1665


what is universe null

1991


how get the grand total in master-detail report?

1819


Can anybody tell me what are the tuning problems?

1592


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1779


How to schedule the report in b.o?

564