BITS WILP Data Warehousing Mid-Sem Exam 2017-H2

survival8: BITS WILP Menu Content

BITS WILP Menu Content

23 comments:

  1. PrashantFebruary 10, 2018 at 7:02 AM

    Awesome...

    ReplyDelete
    Replies
    1. AnonymousApril 17, 2022 at 10:22 AM

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now

      >>>>> Download Full

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK

      >>>>> Download Now

      Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full

      >>>>> Download LINK Ye

      Delete
  2. UnknownApril 26, 2018 at 10:20 AM

    i tried mailing you , but it is not going through. Can you please share the answers to this question paper if you have.

    Thanks

    ReplyDelete
    Replies
    1. Ashish JainApril 27, 2018 at 5:59 AM

      Mail me at ashishjainblogger@gmail.com
      Mention the subject(s) for which you want help.

      Delete
  3. UnknownAugust 14, 2018 at 12:26 AM

    Thanks for putting up the content in such organized manner.Great Help. Thumbs UP !!

    ReplyDelete
  4. AnonymousJanuary 3, 2020 at 10:25 PM

    Recorded lecture links are not working please help

    ReplyDelete
  5. Sid's CurbJune 18, 2020 at 3:36 PM

    Is there a group/whatsapp group for Mtech in computing systems and Infrastructure?

    ReplyDelete
  6. UnknownAugust 5, 2020 at 10:44 AM

    Very useful .. Thank you very much

    ReplyDelete
  7. quantaedsolutionsNovember 30, 2020 at 7:23 AM

    Are you Looking for Smart Device Development? QuantaEd Solutions is the Best Smart Device Development Company, We design and develop smart devices that suit the healthcare requirements. For any inquiry call us we will provide all kind of assistance. For more details visit- https://quantaedsolutions.com

    ReplyDelete
  8. rithiAugust 7, 2021 at 3:19 AM

    This post is so interactive and informative.keep updating more information...
    Software Testing Courses in Mumbai
    Software Testing Training in Ahmedabad
    Software Testing Courses in Kochi
    Software Testing Courses in Trivandrum
    Software Testing Courses in Kolkata

    ReplyDelete
  9. Keerthi55September 26, 2021 at 11:35 PM

    Thanks for the blog article.Thanks Again. Keep writing.
    java online training hyderabad
    java online training in india

    ReplyDelete
  10. Keerthi55September 26, 2021 at 11:45 PM

    Thanks for the blog article.Much thanks again. Fantastic.
    online training in java
    online training on java

    ReplyDelete
  11. Dandy AdamOctober 15, 2021 at 6:42 PM

    AI & ML in Dubai
    https://www.nsreem.com/ourservices/ai-ml/
    Artificial intelligence is very widespread today. In at least certainly considered one among its various forms has had an impact on all major industries in the world today, NSREEM is #1 AI & ML Service Provider in Dubai
    1634348519669-9

    ReplyDelete
  12. Tejaswini WaldeNovember 21, 2021 at 1:45 AM

    Thank you for giving valuable information about software for portable device, we can also develop custom software from pixabulous design.

    ReplyDelete
  13. bhanuDecember 1, 2021 at 5:42 AM

    Nice Blog!!!
    ServiceNow Training
    ServiceNow Online Training in Hyderabad

    ReplyDelete
  14. williambrittoDecember 14, 2021 at 5:24 AM

    This article explains in a clear manner. Nice way of explaining. Thanks for sharing. cloud engineering services

    ReplyDelete
  15. Keerthi55December 17, 2021 at 11:04 PM

    I really liked your blog post.Much thanks again. Awesome.
    java online training
    java training

    ReplyDelete
  16. APTRONDecember 17, 2021 at 11:06 PM

    Data Science Training In Noida
    Data Science course In Noida

    ReplyDelete
  17. Shri Venkateshwara UniversityJanuary 21, 2022 at 1:05 AM

    WILP is a set of educational programs designed in such a way that they can be easily integrated into your work life. Earlier, only highly developed nations like the US and Europe were indoctrinating WILPs but now the WILP in India have also gained a lot of popularity.

    ReplyDelete
  18. Online Shiksha | Online Tuition Classes and Education TipsApril 11, 2022 at 6:10 AM

    Candidates who wish to take the BITSAT should begin studying as soon as possible. Due to the high level of competition, it is critical to follow the best BITSAT 2022 preparation tips recommended by professionals. This blog post contains BITSAT 2022 study suggestions as well as exam pattern and syllabus information. Continue reading to get answers to all of your questions. To know more information visit @ SSSi Online Tutoring Services.

    ReplyDelete
  19. AnonymousApril 17, 2022 at 10:22 AM

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now

    >>>>> Download Full

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK

    >>>>> Download Now

    Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full

    >>>>> Download LINK bO

    ReplyDelete
  20. SairamrealtekAugust 16, 2022 at 9:55 PM

    "Thanks for sharing this informative blog on Best Software Development company in chennai,Software Development Company in chennai,
    Best Software Development company in india,
    Top software development company in chennai,
    Software Development Company in india"

    ReplyDelete
  21. MasterclassspaceMarch 26, 2025 at 1:26 AM

    The BITS Pilani Admission Process is designed to select the brightest minds for its world-class programs. With its independent entrance exam, BITSAT, and direct admission opportunities for board toppers, the institute ensures that only the most deserving candidates secure a place.

    ReplyDelete

Subscribe to: Posts (Atom)

BITS WILP Data Warehousing Mid-Sem Exam 2017-H2
Data Warehousing (SSZG515) EC2R SEM1 2017-18 (Closed Book)


…
Q. 4: Compare and contrast between ‘Application Orientation’ and ‘Subject Orientation’ with relevant examples. [6]
A. 4: Here, differences and similarities born out of using OLTP (application oriented) and OLAP (subject oriented) systems can be written.

Q. 5(B): What do you mean by degenerate dimension? What is its use in dimension modeling?
A. 5(B):
Degenerate Dimension
·         A degenerate dimension is represented by a dimension key attribute(s) with no corresponding dimension table
·         Occurs usually in line-item oriented fact table design

…
Question 5(D): Give four examples of OLAP queries.
Answer 5(D):
Oracle SQL queries for OLAP:
1. This example of ROLLUP uses the data in the video store database.
  SELECT Time, Region, Department,
   sum(Profit) AS Profit FROM sales
   GROUP BY ROLLUP(Time, Region, Dept)

Calculating Subtotals without ROLLUP
The result set in Table 20-1 could be generated by the UNION of four SELECT statements, as shown below. This is a subtotal across three dimensions. Notice that a complete set of ROLLUP-style subtotals in n dimensions would require n+1 SELECT statements linked with UNION ALL. 
SELECT Time, Region, Department, SUM(Profit)
 FROM Sales
 GROUP BY Time, Region, Department
UNION  ALL
 SELECT Time, Region, '' , SUM(Profit)
 FROM Sales
 GROUP BY Time, Region
UNION ALL
 SELECT Time, '', '', SUM(Profits)
 FROM Sales
 GROUP BY Time
UNION ALL
 SELECT '', '', '', SUM(Profits)
 FROM Sales;
 
OUTPUT:
Table 20-2 ROLLUP Aggregation across Three Dimensions
Time Region Department Profit
-------------------------------------------------------------
1996       Central VideoRental       75,000
1996       Central VideoSales          74,000
1996       Central [NULL]                  149,000
1996       East        VideoRental       89,000
1996       East        VideoSales          115,000
1996       East        [NULL]                  204,000
1996       West     VideoRental       87,000
1996       West     VideoSales          86,000
1996       West     [NULL]                  173,000
1996       [NULL]  [NULL]                  526,000
1997       Central VideoRental       82,000
1997       Central VideoSales          85,000
1997       Central [NULL]                  167,000
1997       East        VideoRental       101,000
1997       East        VideoSales          137,000
1997       East        [NULL]                  238,000
1997       West     VideoRental       96,000
1997       West     VideoSales          97,000
1997       West     [NULL]                  193,000
1997       [NULL]  [NULL]                  598,000
[NULL]  [NULL]  [NULL]                  1,124,000
…………………………………………………………..
Optimized "Top-N" Analysis:
select ROWNUM AS Rank, Name, Region, Sales from 
  (select Name, Region,  sum(Sales) AS Sales 
      from Sales GROUP BY Name, Region
      order by sum(Sales) DESC)
WHERE ROWNUM <= 10
---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   ---   --- 


Tags: BITS Pilani, Work Integrated Learning Program (WILP), Previous Year Question Papers, Data Warehousing.

No comments:

Post a Comment

Subscribe to: Posts (Atom)