Answer Posted / sharma
A Staging area simplifies building summaries and general
warehouse management.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Explain what is difference between query studio and report studio?
Explain dimensional modelling?
How can we do data cleaning?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is the metadata extension?
Explain the difference between keylokup and joiner?
Explain piconet?
Explain degenerate dimension table?
what is difference between drill & scope of analysis?
What is the difference between static cache and dynamic cache?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
what are the others of "bad files" and "discard files" when using sql*loader?
What is the difference between constraind base load ordering and target load plan?
What is degenerate dimension table?
What is metadata in context of a datawarehouse and how it is important?