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 star and snowflake schemas?
what is parallel query?
What is the advantages data mining over traditional approaches?
What is a core dimension?
What is a relationship?
What are templates in which way it is help full?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is defined as partial backup?
What are various warehousing tools?
What are the different models used in cluster analysis?
What is type 2 version dimension?
Explain about core dimension, balanced dimension, and dirty dimension?
How to pivot data using informatica when you have variable amount of pivot rows?