Answer Posted / elango
Information sources may be unreliable and may purge data. On
the other hand, information at the warehouse is under the
control of the warehouse users; it can be stored safely and
reliably for as long as necessary.
| Is This Answer Correct ? | 8 Yes | 52 No |
Post New Answer View All Answers
What is the difference between agglomerative and divisive hierarchical clustering?
Explain what are fact, dimension, and measure?
What are the key columns in Fact and dimension tables?
What is data stream and data adaopter. Is it same are different? Explain?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Difference between PowerPlay transformer and power play reports?
What are the steps to build the datawarehouse?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are components of reportnet?
Explain what are the various transformation available?
What is execution plan?
How to know the time taken for particular report execution?
What is Active Datawarehousing?
Why is dimensional normalization not required?
Explain can a dimension table contains numeric values?