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?
Latest Answer: Triggers are stored procedures that are invoked when certain conditions or
events occur. The granularity and flexibility of the conditions and events that
cause a trigger to fire are database specific. This technique assumes that the
DBMS supports ...
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
Latest Answer: Innmons approach is better to load data from Data Marts. ...
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: A data mart is a group of subjects that are organized in a way that allows them to assist departments in making specific decisions. For example, the advertising department will have its owndata mart, while the finance department will have a data mart ...
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
