Both differed in the concept of building teh datawarehosue.. According to Kimball … Kimball views data warehousing as a constituency of data marts. Data marts... Read more »
No Tool testing in done in DWH, only manual testing is done. Read more »
Bus Schema : Let we consider/explain these in x,y axis Dimension Table : A,B,C,D,E,F Fact Table: R,S ... Read more »
Every company has methodology of their own. But to name a few SDLC Methodology, AIM methodology are stardadly used. Other methodologies are AMM, World class methodology... Read more »
Conformed dimensions are those table that have a fixed structure. there will b no need to change the metadata of these tables and they can go along with any number... Read more »
Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model. E-R modeling is used for normalizing the OLTP database... Read more »
I somewhat disagree venkat. There can just be SKs within a Star schema, which itself is de-Normalized. Now, if there are then FKs on the dimensions as well, I... Read more »
Both differed in the concept of building teh datawarehosue.. According to Kimball … Kimball views data warehousing as a constituency of data marts. Data marts... Read more »
Normal Views are for Access purpose ie One need to give access the end user to specific data. Materialized Views are to optimize the performance . WHen materialzied... Read more »
Data Mining is used for the estimation of future. For example, if we take a company/business organization, by using the concept of Data Mining, we can predict the... Read more »
There are three types of architectures. Datewarehouse Basic Architecture : In this architecture end users access data that is derived from several sources through... Read more »
Degenerated Dimension is a dimension key without corresponding dimension. Example: In the PointOfSale Transaction Fact table, we have: Date Key (FK),... Read more »
Normally Surrogate keys are sequencers which keep on increasing with new records being injected into the table. The standard datatype is integer Read more »
What is rapidly changing dimension? There is no Dimension called Rapidly changing dimension in DWH. But if you consider overall ODS tables; a rapidly changing dimension... Read more »
Let me give an example to make the point clear…. Like account information is usually maintained in two categories: Current Account and other is Time of Event... Read more »