-
What is the role of surrogate keys in data warehouse and how will u generate them?
Anindya1281
- Jun 5th, 2011
surrogate key is a substituted key for the business key in data warehouseThis is generated while the loading process (ETL)attributes of surrogate key1) It has the same granularity of the Business Key ...
bcsandip
- Oct 8th, 2010
Along with Jeff's answer, the surragate key also distinguish 2 records with the same combined primary key in the denormalized DWH tables where history is maintained.
-
What are late arriving Facts and late arriving dim ? How does it impacts DW?
Sukanya Das
- Jun 4th, 2011
Late arriving Fact table:For example there was a credit card of transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2007. During this period there is a possibility of change...
Are Ramakrishna Rao
- Aug 14th, 2007
Late arriving Fact table:??????? This is rarely happens in practice. For example there was a credit card of HDFC transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2...
-
How do you join the data from multiple Data Marts ? if so what would be the criteria?
Anindya1281
- Jun 5th, 2011
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...
-
What is a dimension table
Answer posted by Riaz Ahmad on 2005-06-09 14:45:26: A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes.
Read Best Answer
Editorial / Best Answer
Answered by: Edmond
- Apr 13th, 2007
Let's be very clear. this is a very simple, and becomes a very confusing subject.
A fact table is an entity representing the numerical measurements of the business. A dimension table is the entity describing the textual representation of the business.
In a banking model, the account and balances are the measurements within the fact table, where customer name, social security, address, time period of the account, are the dimensions (customer/time).
Hope this answers the clarification.Anindya1281
- Jun 5th, 2011
In very simple termsFact : this contains all numeric attributesDimesion : this contains all non numeric , textual attributesIn order to rememberFact : Any answer to What user want to see is factfor ex...
mickey_gupta
- Mar 4th, 2009
Dimension table contains reference data which gives meaning to fact data. You can also view them as parameters across which you want to analyze the fact data.
-
What is Fact table
Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.
munavar.shaik
- Jan 20th, 2011
A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts tableA dimension table is the entity describing th...
ashwinijawalgekar
- Jun 9th, 2010
Fact table is a normalized table divided in to 2 parts Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension t...
-
What is Normalization, First Normal Form, Second Normal Form , Third Normal Form
Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain scalar or atomic values. 2 N.F:- Table should be in 1N.F + No partial functional dependencies 3 N.F :-Table should be in 2 N.F + No transitive dependencies
dstorkey
- Mar 24th, 2009
To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key.
Jyothsna Tallapally
- May 10th, 2006
Normalization:It is the process of efficiently organizing data in a database.There are 2-goals of the normalization process: 1. Eliminate redundant data 2. Ensure data dependencies make sens...
-
I want to know how to protect my data over networ.which software will be use
udgar213
- Apr 13th, 2011
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.
-
What is Dimensional Modelling
rajnsuccess
- Jan 10th, 2011
Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimen...
kevin0209
- Aug 30th, 2010
Dimension modelling is a logical design technique that seeks to present the data in a standard framework that allows users for high performance accesss.
-
Transmission Media
What do you mean by Transmission Media? Describe various types of Transmission Media.
shreya890
- Feb 15th, 2011
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
-
Final Component of Dimensional Model
As a final component of the dimensional model, the architect can do all of the following EXCEPTA) identify entity relationships.B) add relevant dimensional attributesC) identify derived measuresD) identify derived facts
charlie2k
- Nov 27th, 2010
Identify the relationship is one of the first things to do. It is used for preparing the conceptual data model.The preparation of conceptual data model --> logical data model --> physical data model.
-
High Speed Power Application
Which one of the following is used for high speed power application? a) BJT b) MOSFET c) IGBT d) TRIAC
-
Non-Additive Facts
Give an example of non-additive facts?
rummyraj
- Oct 13th, 2010
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...
-
Explain ODS and ODS types.
chand.abinitio
- Sep 27th, 2010
ODS is defined as subject-oriented and integrated data and volatile
repository of data.
Contains current or near to current data
could be used for day to day reporting/ low-level analysis
updatable data store
contains detail data, no summarization
data in homogeneous form.
jaggu_mandya
- Jan 11th, 2008
It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.data here is volatile
-
What is DATA integration
OM PRAKASH JHA
- Sep 7th, 2010
Data integration involves data combining in different residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations bo...
tisha24
- Oct 22nd, 2009
Data from different sources (like flatfiles, CSV, oracle, db2,teradata, mainfraes etc.) are extracted and transformed in to a single specific pattern (unique structure) and is know as integration of d...
-
What are Aggregate tables
kevin0209
- Aug 30th, 2010
Aggregate table contains summarised data. The materialized view are aggregated tables.
sixto.dsilva
- Oct 1st, 2008
Aggregate table contains the summary of existing warhouse data , it contains data which is group accordingly (month , quartely etc) depending upon the business needs.For example you may contain transa...
-
Data Mart Entity
If data is missing that is required as a primary key in a data mart entity from what sources can this information be gathered?
preekon
- Aug 24th, 2010
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 ...
-
What is the need of surrogate key;why primary key not used as surrogate key
bcsandip
- Jul 16th, 2010
In DW, a fact table stores a few Primary keys of the corresponding Dimension tables. It will be always easier to get the desired record from the fact table when query is fired based upon a particular unique column and that is the another reason to introduce surrogate key.
srinuv_11
- Dec 8th, 2006
Datawarehousing depends on the surrogate key not primary key, for suppose if u r taking the product price it will change over the time, but product no. will not change but price will change over...
-
What is real time data-warehousing
ashwinijawalgekar
- Jul 7th, 2010
The Real time data warehouse is really a combination of real time (Current) and historical data warehouse.In real time world the historical systems are less valuables because of issues facing managers...
satyambabu
- Mar 22nd, 2006
Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose.
-
What is data mining
Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high risk people to insure in a certain geographial area.
kumarram
- Jun 11th, 2010
Data mining is the concept of extracting information from large data bases likes data wharehouse.
raj.rajeev15
- Sep 13th, 2009
Datamining is nothing but a science of finding information from databases or datasets.
-
What are Data Marts
Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes complete individual data warehouses which are usually smaller than the corporate data warehouse.
ashwinijawalgekar
- Jun 9th, 2010
Data Marts: Data Mart is a subset of Data Warehousing. Depending upon the management decision the warehouse devides into smaller part according to their respective subject. eg sales is a data mart of xyz warehouse
spatnam
- Dec 9th, 2008
Datamart is a subset of datwarehouse. Data mart deals with single line of business like Sales, Purchase etc. Size of data will be less when compared to Datawarehouse.Some of the different types of datamart are Depndant datamart , Independant datamart, Hybrid datamart
Data Warehousing Basics
Read Best Answer
Ans