define ods,dss,and olap.
a
s
define ods,dss,and olap.
@vasu,
ods - operation data store is the database where the recent information is stored. In ods (based on the company requirement), they will store the data for recent days/months/years.
dss - decision support system is the end user system where business users analyze the data and take decisions for the forecast of the company growth.
olap - online analytical processing - dimensional modeling starts with the context of olap.
hope this will be helpful up to some extent.....
www.dwforum.net
Last edited by sanghala; 10-30-2007 at 04:22 AM.
ODS: Operational Data Store. The form that data warehouse takes in the operational environment. Operational data stores can be updated, do provide rapid and consistent time, and contain only a limited amount of historical data.
DSS: Decision Support System. Software that supports exception reporting, stop light reporting, standard repository, data analysis and rule-based analysis. A database created for end-user ad-hoc query processing.
OLAP: OnLine Analytical Processing system. Describes the activities and systems associated with a company's day-to-day operational processing and data (order entry, invoicing, general ledger, etc.).
explain about tunning in data stage
thank u for u r ans