define ods,dss,and olap.
Printable View
define ods,dss,and olap.
[quote=svasu.dwh;19799]define ods,dss,and olap.[/quote] [b][color=red]@vasu[/color][/b],
[font=times new roman][size=3]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. [/size][/font]
[font=times new roman][size=3]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. [/size][/font]
[font=times new roman][size=3]olap - online analytical processing - dimensional modeling starts with the context of olap. [/size][/font]
[font=times new roman][size=3]hope this will be helpful up to some extent.....[/size][/font]
[url]www.dwforum.net[/url]
[B][I][U]ODS:[/U][/I][/B] 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.
[B][U][I]DSS:[/I][/U][/B] 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.
[B][U][I]OLAP:[/I][/U][/B] 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