Latest Answer : Active Data Warehouse is the DWH that enables the decision makers of the organisation to understand the trends and patterns of the market (by analysing the captured transactional data in the DWH) and thereby helping them to arrive at an INFORMED ...
Latest Answer : As part of Struts FrameWork we can decvelop the Action Servlet,ActionForm servlets(here ActionServlet means which class extends the Action class is called ActionServlet and ActionFome means which calss extends the ActionForm calss is called ...
Latest Answer : There are two kinds of fact tables which don't have any facts at all. They are called FACTLESS FACT TABLES. As per Kimball's law, every M-M relationship is a fact table. They may consists of nothing but keys. First type ...
Latest Answer : Multidimensional databases consolidate and calculate data to provide different views. With Multidimensional databases users can pivot the data to see the information from different view point. It contains Outlines that defines all the elements of the ...
I want to prepare a questionnaire. The details about it are as follows: -1. Identify a large company/organization that is a prime candidate for DWH project. (For example Telecommunication, an insurance company, banks, may be the prime candidate for this)2. Give at least four reasons for the selecting the organization.3. Prepare a questionnaire consisting of at least 15 non-trivial questions to collect requirements/information about the organization. This information is required to build data warehouse.
Latest Answer : In informatica we have an option of 'rebuild cache'. Use that to rebuild cache. ...
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
Latest Answer : 1. The direction of the data load depends on the approach that was adopted while designing the Warehouse and the datamart. If the top down approach, which Kimbal mentions is used, then data will be moved from DW to DM, whereas if Inmons approach ...
