Because bitmapped indexes map values in the column to bits and store only the bit values, storage is reduced by several orders when bitmapped indexes are used.
As per my knowledge in cognos, after creating a report just click beside the report to select whole report and then right click,click on properties and there you may found headers and footers,click on...
Data analysis explains the overall performance of a business organization data can be analyzed based on the ETL tools operations like informatica, data staging...) and the reports generated by the OLAP
data analysis: consider that ur are running a business and u store the data of that in some form say in register or in a comp and at the year end you want know the profit or loss then it ca...
metadata is :The data about data;The structured data about data;A set of independent assertions about a resource.DD is :An intergrated set of system tables;contains definitions of and information abou...
meta data is nothing but information about data.it contains the information(i.e.data) about the graphs ,its related files,abinitiocommands,serverinformation etc i.e. all kinds of information about project related information etc
As the term suggests, a real-time datawarehouse is a system which reflects all changes to its sources in real time. As simple as it sounds, this is still an area of active research in the field. There...
Clustering means grouping of systems where each system has its own resources where as mpp massively parallel processing in this each system has its own memory and diskspace which is also called sharing nothing architecture
SAS gets adopted by the business groups that do not have a large IT support staff as SAS provides the complete DW environment including ETL and reporting in one easy to manage package. See http://www.dwoptimize.com/2007/02/latest-data-warehouse-industry-trends.html for more comparisons.
Hi The SAS system is an integrated system of software products. The core of the SAS system is Base SAS software. plz visit the following link u will get a idea of w...
Context is basically used when we will have conformed dimension in the loop........
mrudula
Mar 28th, 2007
Context is nothing but specifying the name of the paththe place where u cannot resolve the loops with allias there comes concept of contextalias is nothing but the duplicate name of some other table
A virtual or point-to-point data warehousing strategy means that end-users are allowed to get at operational databases directly using whatever tools are enabled to the "data access network"
DTM Stands fo data transformation managerit is a process which runs secondly with every session runit creates main thread for running the session and the main thread creates seperate threads for each ...
Cluster analysis is an exploratory data analysis tool which aims at sorting different objects into groups in a way that the degree of association between two objects is maximal if they belong to the same group and minimal otherwise
Guest
Jan 16th, 2007
Cluster analysis discovers structure in the data we have without explaining why they exist.There are diffrent types of clustering techniques a)block clustering &nbs...
Hierarchical level of datawarehousing is nothing but the concept of generalization and specialization.As we move up the hierarchy the data is more generalized for ex : the location where STATE is more...
In Datawarehousing, Levels are columns available in dimension table. Levels are having attributes.Hierarchies are used for navigational purpose, There are two types of Hierarchies. You can define hier...
1) Data Warehouse architecture is a three tire architecture where there are three tires i) bottom tire : it contains the gateways where they provide the interface b/w the data and the s/m ii) m...
srinivas vadlakonds
Oct 17th, 2006
1) Data warehousing is the repository of intgrated information data will be extracted from the heterogeneous sources. Data warhousing architecture contains the different sources like oralc,flat ...
If you want to run the graph through GDE then after save the graph just press F5 button of your keyboard, it will run automatically. if you want to run through the shell script then you have to fire t...
Ans