Scribd Logo
Upload

Welcome to Scribd!

  • 35 views

    SQL Server Interview Questions (SSIS)

    Uploaded by

    Saurabh Saxena

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    SQL Server Interview Questions (SSIS)

    Uploaded by

    Saurabh Saxena
    35 views4 pages

    Original Title

    SQL Server Interview Questions ( SSIS)

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    35 views4 pages

    SQL Server Interview Questions (SSIS)

    Uploaded by

    Saurabh Saxena

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    10/8/12 SQL Server Interview Questions ( SSIS)

    Upload
    Log In
    Sign Up
    Search books, presentations, business, academics...
    Search
    Explore
    Documents
    Books - FictionBooks - Non-fictionHealth & MedicineBrochures/CatalogsGovernment DocsHow-To Guides/ManualsMagazines/NewspapersRecipes/MenusSchool Work+ all
    categories
    RecentFeatured
    People
    AuthorsStudentsResearchersPublishersGovernment & NonprofitsBusinessesMusiciansArtists & DesignersTeachers+ all categories
    Most FollowedPopular

    SQL Server Training


    Access Videos, Articles and More. SSWUG Community & vConference
    www.sswug.org
    ×
    Language:
    English

    S Q L S e r v e r S S IS In te r v ie w q u e s t io n s : - C a n yo u e x p la in R O L A P , M O L A P
    a n d H O L A P ?

    Taken from my book SQL Server interview questions http://www.flipkart.com/sql-server-interview-


    questions-8183331033/p/itmdyuqz2a6tzhjw?pid=9788183331036&ref=18a53f02-8ad3-4a9a-b79
    f34ad0f80605&srno=m_1_2&otracker=from-search.

    Let first quickly run through full forms.

    ROLAP stands for Relational Online Analytical Processing, MOLAP stands for Multidimensional Onlin
    Analytical Processing and HOLAP stands for Hybrid Online Analytical Processing.

    When we talk about BI it has two kinds of data, one is the actual data and other is the aggregated da
    For instance you can see in the below table we have customer name, quantity, per price and total
    amount. In this case the total amount column is a derived or aggregated data while all the other fiel
    are actual data (detail data).

    Customer name Quantity Per price Total amount


    Shiv 10 100 1000
    Raju 5 10 50

    ROLAP, MOLAP and HOLAP define storage structure for Business intelligence. It defines how the act
    (detail) data and aggregated data are stored.

    ROLAP stores data and aggregated data in relational format. So in this case query performance is lo
    and also latency is low. Low latency means you get aggregated/calculated data instantly.

    MOLAP stores data in cubes i.e. multi-dimensional format. It uses facts, measures and dimension ta
    structure to form a cube (read the previous question for cubes). Multi-dimensional database design
    format is optimized for better query performance. So the performance is much better as compared
    www.scribd.com/doc/109435262/SQL-Server-Interview-Questions-SSIS#fullscreen 1/4
    10/8/12 SQL Server Interview Questions ( SSIS)
    format is optimized for better query performance. So the performance is much better as compared
    ROLAP but the latency is high.

    The latency is high in MOLAP because it needs to fetch data from relational database (operational d

    do calculations / aggregations / and convert the relational structure data to cube structure data.

    HOLAP is a hybrid approach. It’s a combination of MOLAP and ROLAP. HOLAP stores detail data in t
    relational database i.e. (ROLAP) and the aggregated data is stored in to MOLAP (cubes).

    Due to this approach query is faster than ROLAP but not as fast as MOLAP. Latency is less than MOL
    but higher than ROLAP.

    Web based OLAP Client


    for Microsoft Analysis Services download Free Evaluation
    www.ReportPortal.com

    Download
    0
    Go BackComment
    Link
    Embed
    Zoom
    2 of 2
    Readcast
    Tw eet

    0
    Share

    Below is comparison summary table.


    www.scribd.com/doc/109435262/SQL-Server-Interview-Questions-SSIS#fullscreen 2/4
    10/8/12 SQL Server Interview Questions ( SSIS)
    Below is comparison summary table.

    Storage structure Query performance Latency


    ROLAP Relational Low Low
    MOLAP Cubes High High
    HOLAP Relational + Cubes Medium Low

    In case you are fresher to SSIS, SSAS and SSRS you can start seeing our step by step videos from
    http://www.youtube.com/watch?v=I_Ae3suaL-U
    Search This Document
    Search
    Do not forget to see Search
    our SQL History:
    Server interview question videos from www.questpond.com
    Searching...
    Result 00 of 00
    00 results for result for

    p.

    Leave a Comment
    You must be logged in to leave a comment.
    Submit
    Characters: 400
    You must be logged in to leave a comment.
    Submit
    Characters: ...
    About

    About Scribd
    Blog
    Join our team!
    Contact Us

    Advertise with us

    Get started
    AdChoices

    Support

    Help
    FAQ
    Press

    Partners

    Publishers
    Developers / API

    Legal

    Terms
    Privacy
    Copyright

    www.scribd.com/doc/109435262/SQL-Server-Interview-Questions-SSIS#fullscreen 3/4
    10/8/12 SQL Server Interview Questions ( SSIS)
    © Copyright 2012 Scribd Inc.
    Language:
    English

    www.scribd.com/doc/109435262/SQL-Server-Interview-Questions-SSIS#fullscreen 4/4

    You might also like