Answer Posted / sreekanth
Staging area is the place where data is tested for its
correctness , dta is cleaned before it goes to warehouse.
simple live example:
water filter.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain what is analytical or analytic mean?
What are fact, dimension, and measure?
Difference between PowerPlay transformer and power play reports?
What are data modeling and data mining?
What are the approaches used by optimizer during execution plan?
What is scd1 , scd2 , scd3?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is fact less fact table? Where you have used it in your project?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What needs to be done when the database is shutdown?
What does level of granularity of a fact table signify?
what are the all possible features supported modify stage?
I have two universes created by two difference database can we join them in designer & report level? How