Answered Questions

  • Jun 28 2005
    12:14 PM
    17252
    25

    What are the Different methods of loading Dimension tables

    praveen

    • Jun 26th, 2017

    how do you update when customer changed address: on 06-26-2016 -------------- 101,101_address1, on 06-26-2017, customer 101 moved to new loc and 102 added ---------------- 101,101_Address2 ...

    TimeBeing

    • Jan 25th, 2017

    There are 2 types of data loading.
    1. Initial Loading: Data loading for the first time in to Table/Database is called Initial Loading.

    2. Incremental Loading: Inserting new data and updating existing data which comes with new values is Incremental Loading.

  • May 23 2005
    02:01 AM
    8758
    38

    What is a Star Schema

    Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)

    kamesh

    • Jan 30th, 2018

    A join is linked with only one dimension and one fact is called Star chema

    TimeBeing

    • Jan 25th, 2017

    A Fact table is surrounded by multiple Dimension tables and which is look like STAR in graphical design is called "STAR Schema".

  • Aug 26 2004
    04:00 AM
    4113
    38

    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.

    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

  • Aug 25 2005
    04:15 PM
    9684
    44

    What is a Data Warehousing?

    Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources. Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the...

    chandrasekhar

    • Mar 10th, 2017

    The complete process of ETL activities (Extract, Transform and Load) and BI (Business Intelligence for generating reports) are called Data Warehousing.

    TimeBeing

    • Jan 25th, 2017

    Datawarehousing is a process of Designing a database Schema, ETL process and Reporting.