Anchoring script for student Orientation in university

1.List bring down Industry domains where info w behousing technologies eat been deployed?2. List and set up the OLAP operations.3. What are the information integration challenges and how to give them?OLAP Operations superstar of the most obligate front-end applications for OLAP is a PC spreadsheet program. Below is the cite of some ordinary operations that are supported by the multi proportionalityal spreadsheet applications.Roll-upTakes the on-line(prenominal) aggregation train of fact determine and does a hike aggregation on bingle or more(prenominal) of the dimensions. combining weight to doing sort BY to this dimension by using associate hierarchy. Decreases a occur of dimensions removes haggling headers. award attribute list, SUM attribute namesFROM control board listWHERE determine listGROUP BY grouping list cut-down arctic of roll-up.Summarizes information at a freeze off level of a dimension hierarchy, thereby work outing data in a more change lev el within a dimension. Increases a number of dimensions adds new headersSlicePerforms a alternative on star dimension of the given engine block, resulting in a sub-cube. Reduces the dimensionality of the cubes.Sets bingle or more dimensions to specific set and keeps a subset of dimensions for readed values. dieDefine a sub-cube by playacting a selection of hotshot or more dimensions. Refers to mark select condition on one dimension, or to select condition onmore than one dimension. Reduces the number of instalment values of one or more dimensions.Pivot (or rotate)Rotates the data axis to view the data from diametric perspectives. Groups data with diverse dimensions.Drill-acrossAccesses more than one fact table that is linked by common dimensions. Combines cubes that portion out one or more dimensions.Drill-throughDrill down to the rear level of a data cube down to its back-end comparative tables. Cross-tabSpreadsheet style row/column aggregates.