What are the different tracing options available? Can tracing options be set for individual transformations?
Explain multidimensional data models and how they are integrated with the architecture you have already designed
Latest Answer: Aggregate tables are pre-computed totals in the form of hierarchical mutidimensional structure.,whereas materliazed view ,is an database object which caches the query result in a concrete table and updates it from the original database table ...
“A dimension table is wide but the fact table is deep” Explain the statement in your own words.
Latest Answer: Data profiling is a way to find out what is the profile of the information contained in the source. e.g. In a table a column may be defined as alphanumeric. However majority of the data may be numeric. Profiling tools will provide the statistical information ...
Latest Answer: The basic advantage of RAID is to speed up the data reading from permanent storage device (hard disk). Cheers,Ravi Kumar Garre ...
What is the difference between mapping parameter & mapping variable in data warehousing?What are the types of variable available in data warehousing?
Latest Answer: Surrogate keys are the system generated keys and used to eliminate the redundancy in the primary keys. So they are always integer numbers. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
