Skip to main content

DWH Life cycle



DWH Life Cycle:

DWH is a process of building a datawarehouse

1)Requirement gathering

•         It is done by business analysts, Onsite technical lead and client

•         In this phase a BA prepares business requirement specification(BRS)Document

•         80% of requirement collection takes place at clients place and it takes 3-4 months for collecting the requirements

 

 

 

2)Analysis:

•       After collecting the requirements data modeler starts identifying dimensions, facts & aggregation depending on the requirements

•       An ETL Lead & BA create ETL specification document which contains how each target table to be populated from source

 

 

3)System Requirement Specification (SRS)

•       After collection of onsite knowledge transfer offshore team will prepare the SRS

•       A SRS document includes software,hardware,operating system requirements

 

 

4)Data Modeling

•       It’s a process of designing the database by fulfilling the use requirements

•       A data modeler is responsible for creating DWH/Data marts with the following kinds of schema

-            Star schema

-            Snowflake schema

 

5)ETL Development

•       Designing ETL applications to fulfill the specifications documents which are prepared in analysis phase

 

6)ETL Code review:

Code review will be done by developer

The following activities takes place

•       Check the naming standards

•       Check the business logic

•       Check the mapping of source to target

 

 

7)Peer Review:

Code will be reviewed by a team member

•       Validation of code but not data

 

 

8)ETL Testing

Following tests will be carried out for each ETL

Application

•       Unit testing

•       Business Functionality testing

•       Performance testing

•       User acceptance testing

 

 

9)Report development environment:

•       Design the reports to fulfill report requirement templates/Report data workbook(RDW)

10)Deployment:

•       Process of migrating the ETL Code & Reports to a pre production environment for stabilization

•       It is also known as pilot phase/stabilization phase

 

 

11)Production Environment/Go live

* An active/working environment

 

DWH monitored 24/7 by production support

Team

Different types of Projects:

•       Development

•       Production support

•       Enhancement

•       Migration

Labels:

Comments

Post a Comment

Popular posts from this blog

Data modeling

Data Modeling: Model: Model is business representation of information in one or more data sources OLTP                                    DWH   Model          Model                 Model E-R Model    (modify wih ETL)       Dimensional model (Design based on              (Design based on facts and Measures) Entities&Relationships)   Dimensional Modeling: Is a design methodology for designing a DWH It consists of following 3phases to design the Database 1)Conceptual Modeling: •          Understanding the requirements •     ...
Post a Comment
Read more

FM workflow diagram

FM workflow process diagram: A windows based tool used to design metadata Models                        import Datasource------ à FM design and create the project Prepare the metadata project(Presentation layer)--Prepare  the project business view--Create & manage package---setup  security— Publish package---Content store(Metadata)---Reporting interface   Metadata source-Cognos Application •        Cognos impromptu •        Cognos 10.1 model •        Cognos Architect •        Decision stream •        Data Manager •        IBM Data Source   Third party metadata source: •        ERWIN •     ...
Post a Comment
Read more

Book on IBM Cognos 10 written by me-

Here is a book written by me on IBM Business Intelligence Tool COGNOS which is published at the following link- http://www.amazon.com/dp/B00KKSVGPA/ref=rdr_kindle_ext_tmb Anyone who is having prior knowledge in database like oracle can easily learn to develop the business reports by following the screenshot assisted examples. This book will be a good resource for the students who wish to self learn IBM Cognos software.
Post a Comment
Read more