Latest Answer: I think the comments made earlier are not specific.We dont required any seperate space for data mart and data where house unless until those marts are too big or client required.We can maintain both in a same schema. ...
How data in datawarehouse stored after data has been extracted and transformed from hetrogeneous sources and where does the data go from datawarehouse.
Latest Answer: it is a process of identifing and changing the inconsistencies and inaccuracies ...
Latest Answer: dataware house is a container to store the historical datawhere as dataware hosuning is a process or technique to analyze tha data in the ware house ...
Latest Answer: Datawarehousing depends on the surrogate key not primary key, for suppose if u r taking the product price it will change over the time, but product no. will not change but price will change over the time to maintain the full hystorical data ...
For 80GB Datawarehouse How many records are there in Fact Table There are 25 Dimension and 12 Fact Tables
Latest Answer: As The name interprets , Its not a Dimension. But rather can be Quoted as a primary key of the fact, usually a transational Fact like Premium, Money etc. It holds apart from the primary keys of the dimensions as foreign key in the fact.This key is not ...
Latest Answer: static cache stores overloaded values in the memory and it wont change throught the running of the session where as dynamic cache stores the values in the memory and changes dynamically duirng the running of the session used in scd types -- where target ...
Latest Answer: Absolutely!For example, a perishable product in a grocery store might have SHELF_LIFE (in days) as part of the product dimension. This value may, for example, be used to calculate optimum inventory levels for the product. Too much inventory, ...
Latest Answer: Hybrid SCDs are combination of both SCD 2 and SCD 3.Whatever changes done in source for each and every record there is a new entry in target side, whether it may be UPDATE or INSERT. There is new column added to provide the previous record info (generally ...
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
