Data Warehousing Basics

Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. &nb...

to protect data over the server the ..we can use the data encryption technique,the file to be transmitted can be encrypted and send. we can use the protocols like NDM and SFTP to transmit the data.

An aggregate fact table stores information that has been aggregated, or summarized from a detail fact table.  Aggregate fact table ares useful in improving query performance.  Often an aggre...

BO is a ROLAP Tool,
Cognos is a MLAP Tool and
MicroStrategy is a HLAP Tool

Linked CubeA cube can be stored on a single analysis server and then defined as a linked cube on other Analysis servers. End users connected to any of these analysis servers can then access the cube. ...

 Any schema or Table or Report which gives you meaningful information  of  one attribute  wrt more than one attribute is called  a cube.For Ex: In a product tab...

• Date and time (If datetime data type is not supported then you have to have hour/min/sec on a seperate columns)
• Week
• Month
• Quarter
• Year

ER modelling is the first step for any Database project like Oracle, DB2.
1. Conceptual Modelling
2. Logical Modelling
3. Physical Modelling

This depends upon how the ETL is done:If we are loading data using Informatica, the workflow jobs can be scheduled using Autosys or any other scheduler, in which the scripts could check for the condit...

If you are designing a Data Warehouse how can you rely on manual process? better way is to use ETL wherever required or else just extract and load.But you should refresh all your dimensions regularly ...

It is GCID which means Generic Column ID. When a Normalizer transformation is used to read Cobol sources, the Informatica Designer identifies the 'OCCURS' and 'REDEFINES' statements and generates 2 co...

The transformation of keys which are supposed to be used as primary key into generic key by the system is called as key restructuring. The problem is something like this, let us a say there was an ex...

I think transmission media is the media from which you enable the datawarehouse to be accesed via web. I am not sure about different tramission media's

Identify the relationship is one of the first things to do. It is used for preparing the conceptual data model.

Data mart is considered to be a subset of datawarehouse, If the data is missing for primary key and the data source can be gathered from the list of entity derived from dimensions, but data mart ...

Here is an actual example from my current project.We sell Parts globally. Each part is being sold at different price in different regions. Each part has different cost to the company in different regi...

HiOne way of connecting data from multiple datamarts is with the use of confirmed dimensionsConfirmed dimensions are dimensions which are shared between multiple fact tables within a datamart or betwe...

A logical design is conceptual and abstract. You do not deal with the physical implementation details yet. You deal only with defining the types of information that you need. Your logical design shoul...

service requirement means establishing the connection between client and server...right? well if it is then i can guide you that how to connect a client machine to server via repository. once the ser...

The dictionary meaning of Homogeneous is Uniform and Heterogeneous is Mixed. For example if a mapping is using only Oracle sources or Flat files or DB2 or XML or any other then they are called Homogen...