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 ...
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"
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
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...
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
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...
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
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...
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...
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.
Data profiling is a way to find out what is the profile of the information contained in the source. e.g. In a table a column may be defined as alphanumeric. However majority of the data may be numeric...
Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimenstion.
jyothi
Feb 12th, 2007
Drilling across is a process of moving down in the Hierarchy........where one can see the more generalized way of viewing the information.........ex : The year represented in quarter could be drilled across by specifying each month......
The datawarehousing where all the operations activities maintained,?so?that?you?can?access?the?anaysed?data?from?adifferent?place.For example, take bank operations ... if A deposit 10,000/...
Ans