Answer / hema

oltp -- example for oltp is sap r/3.it is optimised by
data storage.read,write access is possible.contains limited
historical data.data base size is finite.

olap--- example for olap is sap bw/bi.It is optimised by
reporting.Only read access is possible.Contains lots of
historical data.Data base size in infinite

Answer / ashok kumar j

OLTP::

It Is Exclusively designed for Transaction purpose only,when we use this for analytical process it will have load on data base.
We can Maintain only transactional data i.e current data.
Integration across different modules is tough task.

OLAP:: It is used for analytical processing.
In This we can maintain the historical data.
Integration across different modules is easy.

Answer / anand

OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.

OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.

Answer / shanu

Security Needs in mySAP ERP (OLTP) – Online transaction
processing
•Transaction-based security
•Driven by:
•Transaction codes
•Specific field values
•Which activities a user can perform
•Focused on getting daily work completed as quickly and
efficiently as possible.

Security Needs in SAP NetWeaver BI (OLAP) – Online
analytical processing
•Analysis-based security
•Driven by:
•InfoProviders
•Queries
•Data
•Different business purpose and goals than OLTP
•Focused on displaying, planning, and analyzing data

Answer / sadaddin

OLAP(online Transaction processing):
It contains the current data.Any system Supports INSERT,DELETE,UPDATE & SELECT operations is also known as OLTP.Because of "Update" & "DELETE" statements it contains Current data.

OLTP(online Analyitical Processing):Report to Report comparision is called Analysis.Data WArehouse contains current data+ historical data for Analysis is named as OLAP

Answer / praneeth

OLTP
IT is a two dimensional table included with ER-model(entity relationship model).here we can analyse only two dimensions.
OLAP
It is a multi-dimensional table included with 4 schemas i.e,
star schema, extended star schema, snow flake and highbrid.
In bi we can use extended star schema.

What is used in sdk for developing a form ?

0 Answers  

How does cell editor works in BEx.

1 Answers   TCS,

Can we format BEx reports/graphs using HTML and CSS

1 Answers  

Which property of matrix gives the total number of rows in the matrix ?

0 Answers  

What are the features of sap business one include?

0 Answers  

hi 1.while monitoring process chains i got an error that "activation was failed"what is the reason for failure and how did u solve that problem? 2.Process chain is going on running but it is not completing ,stopping?what are the necessary steps we have to take to solve the problem? 3.If there is any duplication in the cube ,how to rectify it and how to solve the duplication in the cube? 4.we have created one new field in the extractions which is not presented in the communication structure ,but the problem is how to bring the created field in to the cube? 5.what is meant by compressin? here the problem is we are deleting the request id,s what about the data depending on the id? 6.For improving the query we will create aggregates ? how the internal process will takes place to improve the query? what is meant by aggregate? 7.how to schedule the process chain "in a month first five days "i have to schedule the process chain? how? 8.what is meant by archiving? Support question service level aggrement: If we are unable to solve the ticket with in the service level aggrement? what are the necesary steps we have to take? these are the question i have faced on ibm interview,ok byee thanks&regards suresh kumar

4 Answers   IBM,

Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? Thanks in advance, Phani

6 Answers  

What is the difference between canceling the sales order and closing the sales order?

2 Answers  

How to use abap start routine and end routine what is the code? Where it be coded?

2 Answers   IBM,

Name of the tool used for unit testing

1 Answers   IBM, TCS,

your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage)

1 Answers   Accenture,

what is cell formatting? and advantages?

0 Answers