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
How much data hold in one universe.
How to handle multi value dimensions?
How to stop a batch?
Explain the importance of data warehouse?
What are aggregate transformation?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the types of dimensional modeling?
What is the extension of file to save template?
Explain how many ways you create ports?
What are components of reportnet?
What are the reasons to use a chameleon method in data warehousing?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What according to you might be the future of data warehousing?
What is an error log table in informatica occurs and how to maintain it in mapping?
How are the dimension tables designed?
