In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table...
suganya
Dec 19th, 2005
In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table...
As part of Struts FrameWork we can decvelop the Action Servlet,ActionForm servlets(here ActionServlet means which class extends the Action class is called ActionServlet and ActionFome ...
Aggregate table?contains summarised data. The materialized view are aggregated tables. for ex in sales we have only date transaction. if we want to create a report like sales by product per year. in ...
A data warehousing best practice is to create surrogate keys--typically a meaningless simple integer--for the primary key in each dimension table. The associated fact table rows use this same surrogate as a foreign key reference to the dimension tables.
Multidimensional databases consolidate and calculate data to provide different views. With Multidimensional databases users can pivot the data to see the information from different view point. It cont...
Abhishek
Aug 28th, 2006
What is Multidimensional database? How is it different from Relational database and how it works?
Hi ,I-Bot is a object which we configure in Siebel web catalog for generating auto report to perticular person.See i will give example my manager want the report of perticular sales area that how sell...
Nisith
Apr 3rd, 2007
IBot is an utility available in Siebel Analytics, which is used for reports scheduling as well as Alerts sent to the required recipients on different web accessible / communication devices.
Datawarehouse V/S OLAPBoth the terms are interchangble.DW:Data from different source systems is stored in a relational database for end use analysis.Data is organized in summarized, aggregated,subject...
Guest
Jan 4th, 2007
Don't get confused ,OLAP and Datawarehouse are the terms that can be used interchangeably in some places.Online Analytical Processing is a concept whereas Datawarehouse is the collection of data in denormalized form so that it can help in fast and frequent analysis.
Yes.Because these OLAP systems involved in decision making system of the firm.the historical data which includes in olap systems helps to take business intelligence solutions.
smriti
Jul 12th, 2007
Yes, OLAP databases are called decision support systems because it helps in analysing the historical and present data of the organisations and thereby helping in taking intelligent business decisions
Snapshot is a fact table which describes about the state of things ina particular instance of time. It mainly involves semiadditive or nonadditive facts!
//Semi additive facts//Whenever possible the facts or measure in the fact table should be chosen as perfectly additive. However some measure of intensity is not perfectly additive across all of the di...
jgd.ramesh
Aug 15th, 2007
E-R modelling is entity relation between two table.Dimension modelling is contain three table Aggregate, Fact table, Dimension table
Active Data Warehouse is the DWH that enables the decision makers of the organisation to understand the trends and patterns of the market (by analysing the captured transactional data in the DWH) and thereby helping them to arrive at an INFORMED future decision(s).Thanks.Alpesh
Active Data Warehousing (ADW)The technical ability to capture transactions when they change, and integrate them in to the warehouse - along with maintaining batch or scheduled cycle refreshes.
Data Warehousing: It is a process that includes the extracting the data (from source systems), cleaning, transforming and delivering them to the Data Warehouse (databases) for the loading purpose.&nbs...
Business Intelligence:BI is a broad cateogry of applications and technologies for gathering, integrating, storing, analysing and providing access to data to help enterprise users make better business ...
An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(howev...
A MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(howeve...
Triggers are stored procedures that are invoked when certain conditions or
events occur. The granularity and flexibility of the conditions and events that
cause a trigger to fire are database spec...
Ans