is there any option other than Surrogate key or concatenated key?
Latest Answer: Two main reasons to generate and maintain a surrogate key on DW side:1. If your DW has multiple sources for a dimension or fact, the PK ID fields can have same values from different sources. The only way you can handle this is by maintaining the composite ...
How do you manage the database triggers in DWH?
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 ...
Latest Answer: An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(however physically it is also implemented in the form of ...
Latest Answer: In informatica we have an option of 'rebuild cache'. Use that to rebuild cache. ...
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: Data Mart is subset of dataware house deal with single area of data and is organized by quick analysis. ...
Latest Answer: a data warehousing best practice is to create surrogate keys--typically a meaningless simple integer--for the primary key in each dimension table. The associated fact table rows use this same surrogate as a foreign key reference to the dimension tables. ...
View page [1] 2 3 4 Next >>

Go Top