(NOT AS A RELATIONAL,MULTI, HYBRID?)

ThomasB

 Profile Answers by ThomasB Questions by ThomasB

• Jan 4th, 2008

The FUNCTIONAL difference between these is how they information is stored.  In all cases, the users see the data as a cube of dimensions and facts.ROLAP - detailed data is stored in a relational ...

Sivakumar.R

 Profile Answers by Sivakumar.R Questions by Sivakumar.R

• Dec 7th, 2007

Rolap : Relational Olap,these functionality are used in Business Objects.Molap : Multi Dimensional Olap Functionality are used in Cognos.Hloap  : Hybrid Olap is a combination  of Rolap and Molap.

Answer Question  Select Best Answer

Sivakumar.R

 Profile Answers by Sivakumar.R Questions by Sivakumar.R

• Dec 7th, 2007

Bus Schema : Let we consider/explain these in x,y axis                       Dimension Table :&...

KPIZME

 Profile Answers by KPIZME Questions by KPIZME

• May 23rd, 2006

A BUS Schema or a BUS Matrix? A BUS Matrix (in Kimball approach) is to idetify common Dimensions across Business Processies; ie: a way of identifying Conforming Dimensions.

Answer Question  Select Best Answer

the ODS is technically designed to be used as the feeder for the DW and other DM's -- yes.  It is to be the source of truth.Read the complete thread at http://asktom.oracle.com/pls/ask/f?p=4950:8:16165205144590546310::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:30801968442845,  

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 14th, 2007

Hi According to Bill Inmon's paradigm an enterprize can have one datware house and datamarts source their information from the datawarehouse. In the dataware house, information is stroed in 3rd No...

Aruna

• Dec 22nd, 2006

Data Mart is a sub section of Data Warehouse. e.g there is a datawarehouse of a company.Supose there is a datamart for all its departments. The complete company stores large historical data.In this case datamart of a deparment also stores historical data. can ODS be used here?

Answer Question  Select Best Answer

Pratap

• Sep 26th, 2007

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

Answer Question  Select Best Answer

Answer posted by Shri Dana on 2005-04-06 19:04:05: OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge storage of historical information obtained from different datamarts for making intelligent decisions about the organization.

jyotsna

• Sep 6th, 2007

OLTP databases are generally volatile in nature which are not suitable for datawarehouses which we use to store historic data

1292033

• Aug 2nd, 2007

Because OLTP databases are transactional data related databases. The meaning of this is these databases are used in real time to insert, update and delete data. To accomplish these tasks in real time,...

Answer Question  Select Best Answer

nilanjan@wipro

• Aug 22nd, 2007

Architecture 1:Source=>Staging=>DWHArchitecture 2:Source=>Staging=>Datamarts                  &nbs...

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

UR RIGHT BINDU u hav nice concept ,,bye nagthumati_nagaraju@yahoo.co.in

Answer Question  Select Best Answer

desaial

 Profile Answers by desaial Questions by desaial

• Aug 20th, 2007

CUBE is used in DWH for representing multidimensional data logically.  Using the cube, it is easy to carry out certain activity e.g. drill down / drill up, slice and dice, etc. which enables the ...

jahnavi.s

 Profile Answers by jahnavi.s Questions by jahnavi.s

• Sep 20th, 2006

Yes,cube is a logical representation of data.12 steps are required for the creation of cubes.its mainly used for analysis purpose. we can analyse which product can be sold more in which country all these we available in the cube by performing operatoins like roll-up,drill-down,slice and dice

Answer Question  Select Best Answer

Are Ramakrishna Rao

• Aug 14th, 2007

The estimation process is as follows1. We have to estimate the size table wise     for example one fact table having say 50 cols. one of the col size is varchar 200.  &nb...

Guest

• Jan 23rd, 2007

Not possible to estimate. But generally Facts occupy 90% space in database.

Answer Question  Select Best Answer

Are Ramakrishna Rao

• Aug 14th, 2007

Hybrid SCDs are combination of both SCD?2 and SCD 3.Whatever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT.? There is new column added to provide the previous record info (generally it will be?surrogate key)

Pradeep Menon

• Aug 8th, 2006

Hybrid SCDs are combination of both SCD 1 and SCD 2.It may happen that in a table, some columns are important and we need to track changes for them i.e capture the historical data for them whereas in ...

Answer Question  Select Best Answer

siraj khan

• Aug 6th, 2007

ODS means Operational Data store. ODS & Staging layer are the two layers between the source and the target datbases in the data warehouse..ODS is used to store the recent data.

chandrarekha

• May 8th, 2007

ODS is defined as an integrated view of operational data sources designed to support operational monitoring.

Answer Question  Select Best Answer

chandrarekha

• May 7th, 2007

Hierarchy is an ordered series of related dimension objects grouped together to perform the multidimensional analysis.Multidimensional analysis is? a technique to modify the data,so that the data? can be viewed from? different perspectives and at different levels

Satish

• Oct 6th, 2006

A related group of dimentions grouped together to perform multi dimentional analysis is known as Hierarchy.

Answer Question  Select Best Answer

Stephen

• Apr 6th, 2007

Junk Dimension also called as garbage dimension. A garbage dimension is a dimension that consists of low-cardinality columns such as codes, indicators, status,and flags. The garbage dimension is also referred to as a junk dimension. Attributes in a garbage dimension are notrelated to any hierarchy.

Rajkumar

• Sep 5th, 2006

A junk dimension is a convenient grouping of flags and indicators. It's helpful, but not absolutelyrequired, if there's a positive correlation among the values. Their benefits: Provide a rec...

Answer Question  Select Best Answer

kalyani

• Mar 28th, 2007

Source qualifier is a transformation which extracts data from the source. Source qualifier acts as SQL query when the source is a relational database and it acts as a data interpreter if the source is a flatfile.

sandrag

 Profile Answers by sandrag Questions by sandrag

• Feb 7th, 2007

Source qualifier is an transformation which every mapping should have , it defines the source metadata to the Informatica Repository.The source qualfier has different properties like filtering records , and joining of two source , and so on .

Answer Question  Select Best Answer

testuser

• Mar 15th, 2007

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

Answer Question  Select Best Answer

manisha.sinha

 Profile Answers by manisha.sinha Questions by manisha.sinha

• Dec 29th, 2006

create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feil...

Raghunath Bhairavajosula

• May 12th, 2006

Generally we load the Time dimension by using SourceStage as a Seq File and we use one passive stage in that transformer stage we will manually write functions as Month and Year Functions to load the ...

Answer Question  Select Best Answer

A 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. This arrangement avoids the more costly alternative of storing and maintaining copies of a cube on multiple analysis servers. linked cubes can be connected using TCP/IP or HTTP. To end users a linked cube looks like...

Amit Sagpariya

• Nov 20th, 2006

Hi All,Could you please let me know what is Replicate Cube & Transparent Cube?Thanks & regards,Amit Sagpariya

Amit Sagpariya

• Nov 20th, 2006

Hi All,Could you please let me know what is Replicate cube &

Answer Question  Select Best Answer

Shiva

• Nov 11th, 2006

 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...

Answer Question  Select Best Answer

chandu

• Nov 1st, 2006

A fact,which can be used across multiple datamarts is called as conformed fact.

praveen_pspk

• Sep 9th, 2006

Confirmed dimensiobs are the dimensions that we can use across multiple datamarts in combination with fact tables.Ex: Time dimension

Answer Question  Select Best Answer

Sravan Kumar Gopisetty

• Sep 1st, 2006

1.Understand the bussiness requirements.2.Once the business requirements are clear then Identify the Grains(Levels).3.Grains are defined ,design the Dimensional tables with the Lower level Grains.4.On...

prashanthmcr

 Profile Answers by prashanthmcr Questions by prashanthmcr

• Aug 29th, 2006

You can also the book "The Datawarehouse Toolkit" By ralph kimball and margy ross. I found it extremely helpful.PrashanthCheck the website www.intelligententerprise.com . It is quite informative and has very useful articles.

Answer Question  Select Best Answer

Sphurti

• Aug 16th, 2006

I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and foreign key data needs to...

smithareddy

• Jul 19th, 2006

Normalized View-> Process of eliminating the redundencies.Denormalized View-> process the data where duplication takes place. Which means it is not stop the replication.

Answer Question  Select Best Answer