• Home
  • ankeshjain Answers

Answered Questions

  • Jul 14 2008
    10:06 AM
    20129
    27

    What are the steps to build the data warehouse?

    • josri

    Star Read Best Answer

    Editorial / Best Answer

    ankeshjain  

    • Member Since Aug-2008 | Aug 17th, 2008

    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
     

    Ravi Teja N

    • Sep 16th, 2011

    The steps used to develop a DWH are 1. Gathers Operational Source System 2. Data Staging Area 3. Data presentation Area 4. Data Access Tool Lets have a detailed information about each stage: Operat...

    mohanbabu

    • Aug 20th, 2011

    We can create the dwh in two ways i.e
    1. top down approach
    2.bottom up approach