-
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
-
What Snow Flake Schema
Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...
prodyot.sarkar
- May 13th, 2010
Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...
harshadapj
- Jul 22nd, 2008
Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...
-
What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?
Sam Kolta
- Apr 17th, 2010
User It is just an account name for the user Owns a schema Have the same name Create user command, create the user User can be considered schema User can created without schema It is the account for t...
senthil kumar B
- Feb 13th, 2006
Diff b.w OLTP and OLAP :------------------------OLTP Schema :* Normalized * More no.of trans* Less time for queries execution* More no.of users* Have Insert,delete and update trans. OLAP (D...
-
How are the Dimension tables designed
divya29july
- Feb 11th, 2010
Dimension table contain the textual descriptors of the business. In a well designed dimemsion model, dimension table has many columns or attributes. Fields that are discretely valued description that ...
Kenny
- Jul 19th, 2005
Find where data for this dimension are located. Figure out how to extract this data. Determine how to maintain changes to this dimension (see more on this in the next section). Change fact table and DW population routines.
-
What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
divya29july
- Feb 11th, 2010
Factless Fact table:Consider an example of Product on promotion, the fact table will contain information of only the products that were on sale and sold but not of those that did not sell as the fact ...
siraj.khan
- Aug 3rd, 2007
Semi-additive facts are those facts which can be aggregate according to the context. so, it can contain a fact but the factless fact table does not contain fact's but it contains the dimmentions. It's a type of a dimmentions.
-
opposite is true?
">Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
justins707
- Jan 11th, 2010
When we refer to Star and Snowflake Schemas, we are talking about a dimensional model for a Data Warehouse or a Datamart. The Star schema model gets it name from the design appearance because th...
Chris
- Mar 29th, 2007
Star Schemas generally contain fact tables with fully denormalised dimension tables connecting directly to the fact table. A snowflake schema is a modification of this approach whereby the dimension t...
-
What is the life cycle of data warehouse projects
idanh79
- Dec 7th, 2009
1. project planning2. business requirement definition3. dimension modeling+ technical architecture design4. pysical design+ product selection5. data staging design and development+end-user application development6. deployment+QAIdan Halfon
sulee
- Aug 22nd, 2007
STRAGEGY & PROJECT PLANNINGDefinition of scope, goals, objectives & purpose, and expectationsEstablishment of implementation strategyPreliminary identification of project resourcesAssem...
-
Can you convert a snowflake schema in to star schema?
idanh79
- Dec 1st, 2009
Yes, you can do it by denormalization of the dimensions into one (and wide) dimension, it is depends of your needs.Idan Halfon
sixto.dsilva
- Sep 25th, 2008
Yes right said both model are designed for different purpose , I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small , small tables. If...
-
Bridge Table
What is the use of bridge table. Can give a simple example?
Read Best Answer
Editorial / Best Answer
Sirini- Member Since Jun-2009 | Jun 14th, 2009
An example of a Bridge table would be relationship table between student_master and courses_master. A Student may participate in multiple courses and obviously in a course there will be multiple students. In this scenario to maintain relationships between student_master and courses_master we need another table, which may be called, Student_courses. This table will have all relationships between Students and Courses.A bridge table is a table that only contains the keys between the two tables in a many-to-many relationship. These tables typically consist of mostly key fields, the primary keys of the two tables needing the many to many relationships. Sometimes there are more data elements, but often there are only two columns, both foreign keys.
vijsarav11
- Oct 19th, 2009
Hi all... This is my view on bridge tables:Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id...
tisha24
- Oct 7th, 2009
A table which maintained to define the relationship between two different tables is known as bridge tables. For example, say there are two tables one table with employee information (an employee table...
-
What is CGID in normalizer transformation
Please provide me deep info on Normalizer !
Sirini
- Jun 14th, 2009
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...
-
What is ETL
ETL is extraction,transformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary transformations done in between.
rsp2709
- Jun 8th, 2009
ETL is a process that extracts data from one database, transforms it as per the destination database and loads it into another database. In the transformation process, data is actually standardized to...
jaggu_mandya
- Jan 16th, 2008
Data Acquisition technique is now called ETL(Extraction, Transformation and Loading)Extraction-The process of extracting the data from various sources. Sources can be file system, database, XML file, ...
-
ODS and Staging
What is the difference between ODS and Staging?
prat4all
- May 25th, 2009
ODS keeps the transactional data from where direct reporting is possible. The data in ODS can be partly denormalized.Staging area is the exact replica of the transactional database which acts as a source for datawarehouse processing.
shanavaz
- Nov 1st, 2008
ODS, Operational Data Store is majorly different from Staging in the below aspects: - Existing Records in the System can get updated based on necessary instructions & design. - It can be use...
-
What is ER Diagram
Answered by Puneet on 2005-05-07 04:21:07: ER - Stands for entitity relationship diagrams. It is the first step in the design of data model which will later lead to a physical database design of possible a OLTP or OLAP database
sukhdev_ce
- Apr 30th, 2009
The ER Diagrams is the initial process to analaysis a database application, and understands the problems related or causes in future with the choosed database application, in this satge different comp...
clickharri
- Apr 22nd, 2008
Entity Relationship Diagrams are a major data modelling tool and will help organize the data in your project into entities and define the relationships There are three basic elements in ER models: Ent...
-
What is the differences between the static and dynamic caches?
ramakrishna.inf
- Apr 21st, 2009
Static cache - It doesn't reflect changes once data is cached is known as static cache.
Dynamic cache - It reflect to changes at the time of running the session if any updates happen in source data.jayadhar
- Sep 4th, 2006
static cache stores overloaded values in the memory and it wont change throught the running of the session where as dynamic cache stores the values in the memory and changes dynamically duirng the run...
Data Warehousing Basics
Read Best Answer
Ans