-
What is the business rule for writing the requirement?
sixto.dsilva
- Sep 11th, 2008
Business rule is nothging the transformation requirement which will convert the raw data into business users required presentation so that business users can query and do the analysis on the Data.
abcde
- Jun 27th, 2008
Business Rulw is nothing but a transformation needs to be applied on the dataacoording to the user requirement. e.g. in trading system notional value willbe multiplication of(fund price* shares)
-
How do you load the data conditionally by run steps ?
DWH01
- Jul 8th, 2008
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...
-
General flow for feasbility study
Outline the procedure for the feasbility study of building datawarehouse for a company.
-
Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions.
Read Best Answer
Editorial / Best Answer
jaggu_mandya- Member Since Jan-2008 | Jan 17th, 2008
OLTP(1)---->ODS(2)------>DWH(3)-------->OLAP(4)------------>Reports(5)------>decision(6)
1-2 (extraction)
2-3 (Transformation and here ODS is itself staging area )
3-4-5 (Use of reporting tool and generate reports)
6-decision is taken i,e purpose of datawarehouse is servedI think this is right picture
wnthanuja
- Jun 19th, 2008
Source System data ----------Extraction---------Transformation(Clenance the data according to business logics)(As dimensions)----------Takes data from the dimension tables in to fact tables using Surrogate keys---------------Load (As cubes)(In to the staging)
verma_tushar
- Mar 5th, 2008
In some of the cases Pre Stage is also a intermediate phase between the OLTP environment and actual staging area.The prestage is one where dta clensing, data profiling nad data validation takes place....
-
Explain the situations where snowflake is better than star schema
DWAlchemist
- Apr 11th, 2008
A snowflake schema is a way to handle problems that do not fit within the star schema. It consists of outrigger tables which relate to dimensions rather than to the fact table.The amount of spac...
ghoshkunal123
- Feb 5th, 2008
Star schema is good for simple queries and logic. But snowflake schema is good for complex queries and logic. Snowflake schema is nothing but an extension of the star schema in which the dimension tables are further normalized to reducy redundancy. Hope this helps.
-
What is a general purpose scheduling tool
rpreddy
- Mar 24th, 2008
A sheduling tool is a tool which is used to shedule the datawarehouse jobs...All the jobs which does some process are sheduled using this tool, which eliminates the manual intervension.
Pavan
- Aug 29th, 2005
The basic purpose of the scheduling tool in a DW Application is to stream line the flow of data from Source To Target at specific time or based on some condition.
-
What are conformed dimensions
jaggu_mandya
- Jan 11th, 2008
In Integrated schema Design, a dimension which can be shared across multiple fact tables is called Conformed Dimension.
Sivakumar.R
- Dec 7th, 2007
Any Dimensional Table in a Schema which is Shared by Two Facts Tables are called Conformed dimensions.
-
What is the datatype of the surrgate key
jaggu_mandya
- Jan 11th, 2008
It is a system generated sequence number, an artificial key used in maintaining history.It comes while handling slowly changing dimensions
ankitmohansharma
- Jan 7th, 2008
Hi all, Surrogate key is mostly a sequential number. Although it doesn't has to be. They are system-generated artificial primary key values. Typically, every row would have both a primary key and ...
-
What is meant by Aggregate Factable?
Factable having aggregated calculations like sum, avg, sum(sal)+sum(comm),these are Aggregated FactableCheersPadhu
ThomasB
- Jan 4th, 2008
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...
-
What is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?
(NOT AS A RELATIONAL,MULTI, HYBRID?)
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
- 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.
-
What is BUS Schema?
Sivakumar.R
- Dec 7th, 2007
Bus Schema : Let we consider/explain these in x,y axis Dimension Table :&...
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.
-
Is it correct/feasible develop a Data Mart using an ODS?
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
- 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?
-
-
Why are OLTP database designs not generally a good idea for a Data Warehouse
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.
-
What are the different architecture of datawarehouse
nilanjan@wipro
- Aug 22nd, 2007
Architecture 1:Source=>Staging=>DWHArchitecture 2:Source=>Staging=>Datamarts &nbs...
thumatinagaraju
- Oct 24th, 2006
UR RIGHT BINDU u hav nice concept ,,bye nagthumati_nagaraju@yahoo.co.in
-
What is a CUBE in datawarehousing concept?
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
- 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
-
-
-
-
Data Warehousing Basics
Read Best Answer
Ans