Book Your slot
X
ONLINE BOOKING
BOOK NOW
OFFLINE BOOKING
Call or WhatsApp 7993732682 (WhatsApp Now), 9177341827 (WhatsApp Now)
search
Menu Login home
  • Questions

  • Library

  • University Updates

  • Informatives

  • Technology Lines

  • Training & Internships

  • X
    Menu
  • Home
  • Privacy Policy
  • Legal Disclaimer
  • Terms & Conditions
  • Return Policy
  • About Us
  • Need any help?? write to us at

    support@engineershub.co

    Follow Us

    X
    LOGIN
    Login to access posts, links, updates, question papers, materials, one liners!
    Use Your Email Address/Mobile and Password to Login
    Forgot Password?
    Not a member? Sign Up
    LOGIN WITH EMAIL/MOBILE
    Forgot Password?
    Go Back
    FORGOT PASSWORD
    Go Back
    RESET PASSWORD
    Go Back
    Continue with LinkedIn
    OR
    Fill Up a Simple Form
    Already a Member? Login
    SIGN UP
    Fill all the below details correctly and click on Next
    Go Back
    Write in brief about dimension table? - EngineersHub
    Go Back
    Question
    Pragna Bairu
    7 months ago
    1 Answer(s) posted Write an answer 483
    Answer
    Read Mode
    Answer posted by Vamshi
    6 months ago

    Dimension Table: A Dimension Table, refers to a table, that comprises details about a particular subject area, which helps in processing the query within the database. For instance, time dimension tables can include, Time_id, Time_date, Time_month. Time_year, etc.

    Characteristics of Dimension Table: The following are the characteristics of dimension table,

    1. It has a primary key using which, every individual row in the table can be separately determined.

    2. It has a very large structure, that is distributed horizontally.

    3. It has textual attributes i.e., attributes written in textual format. This format describes the components existing in the business dimensions and is used for query execution.

    4. It has attributes that are not explicitly related to each other.

    5.It has an unnormalized form of data in dimension tables, so as to efficiently process the queries in the database.

    6. It can perform drill-down and roll-up operations, whenever required. If the user wants to retrieve details from higher-level to lower-level of aggregation, then drill-down is performed. On the other hand, if the user wants to retrieve details from lower-level to higher-level of aggregation, then roll-up is performed.

    7. It consists of less number of records than fact tables.

    8. It supports multiple levels of hierarchy.

    Users Joined

    Naveen
    43 minutes ago
    Marla
    17 hours ago
    Vivek Tripathi
    22 hours ago
    Uttam M
    1 day ago
    Poorna Teja
    1 day ago
    X
    Write in brief about dimension table?
    X
    Write in brief about dimension table?

    Dimension Table: A Dimension Table, refers to a table, that comprises details about a particular subject area, which helps in processing the query within the database. For instance, time dimension tables can include, Time_id, Time_date, Time_month. Time_year, etc.

    Characteristics of Dimension Table: The following are the characteristics of dimension table,

    1. It has a primary key using which, every individual row in the table can be separately determined.

    2. It has a very large structure, that is distributed horizontally.

    3. It has textual attributes i.e., attributes written in textual format. This format describes the components existing in the business dimensions and is used for query execution.

    4. It has attributes that are not explicitly related to each other.

    5.It has an unnormalized form of data in dimension tables, so as to efficiently process the queries in the database.

    6. It can perform drill-down and roll-up operations, whenever required. If the user wants to retrieve details from higher-level to lower-level of aggregation, then drill-down is performed. On the other hand, if the user wants to retrieve details from lower-level to higher-level of aggregation, then roll-up is performed.

    7. It consists of less number of records than fact tables.

    8. It supports multiple levels of hierarchy.

    EngineersHub Logo
    x
    Loading...