1)If data is missing that is required as a primary key in a data mart entity from
what sources can this information be gathered?
What do you mean by Transmission Media? Describe various types of
Transmission Media.
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
Fact Table is a) Completely Normalized b) Partially Normalized c) Completely
De-normalized d) Partially De-normalized
Latest Answer: Wherever is a KEY present, that table is somewhat
[Link] tables in a dimentional modelling are always highly
normalized. To make a report or get the entire data about something you
always use a lot of joining with other dimentional tables. ...
What is the use of bridge table. Can give a simple example?
Latest Answer: 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. It can be explained in detailed with
the below [Link], 2 ...
How does replication takes place between two sites?
What are the steps to build data ware house
System Requirement Gathering Selecting Tool. Data Modeling and design ETL
Process OLAP Cube Design Front End Development Performance Tuning User
Acceptance Test ( UAT ) Rolling out to Production Production Maintenance
Ans.
1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
2. Take the source where you have the data to load into datawarehouse
Apply the bussiness logics to that data
Load the transformed data into the target
3. 1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
4. There are four steps to build a datawarehouse architecture.
1] TOP-DOWN
2] BOTTOM-UP
3] HYBRID
4] FEDERATED
Kindly go through the link below for more details.
[Link]/research/[Link]?ID 6699
Hope this helps.
Regards
Soumyadutta Roy
Design Engineer
BusinessIntelligence Platform
Steps Datawarehouse
The fact tables contain quantitative data that might be queried or acquired to measure and the
dimension tables are smaller and hold descriptive data that relates to measure and reflect upon the
data hierarchy in the database.
There are four phases in the development process –
Analysis
Design
Data gathering
Loading phases
Analysis process is completely taken care by analysts which will be having a sound knowledge of the
process to be followed. In general this phase is carried forward by concerned personnel sitting at client
end.
The Design phase includes four tasks which are: identifying measures identifying dimensions and their
hierarchies designing and creating physical models by defining schema of fact and dimension tables.
This process is called high level design.
Furthermore Data gathering phase involves extracting and cleaning data to prepare it for loading into
the warehouse. This phase is called low level design.
The last phase loading phase is to load the prepared data into the data warehouse.
1. Requirement gathering (involved in face to face discussion with the
clients regarding what is their requirement)
2. Data modeling (where we fix the schema design for warehouse)
3. Data profiling
4. Data cleansing
5. ETL ( 1. Extracting the transactional data from the data sources into a
staging area 2. Transforming the transactional Data 3. Loading the transformed
data into a dimensional database )
6. Reporting 1. Building pre-calculated summary values to speed up report
generation 2. Building (or purchasing) a front-end reporting tool
System Requirement Gathering
Selecting Tool.
Data Modeling and design
ETL Process
OLAP Cube Design
Front End Development
Performance Tuning
User Acceptance Test ( UAT )
Rolling out to Production
Production Maintenance
1.