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
What are different deliverables according to phases?
Explain what are the advantages data mining over traditional approaches?
What is an error log table in informatica occurs and how to maintain it in mapping?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What are loops in Datawarehousing?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What are the stages of datawarehousing?
Why should we use data ware housing and how can you extract data for analysis with example?
what is parallel query?
Explain the data type of the surrogate key?
What are data validation strategies for data mart validation after loading process?
Describe a data warehouse.
Explain what are the advantages of query studio compared to report studio?
Explain what does level of granularity of a fact table signify?