Answer Posted / pradip sahoo
A staging area is where data is processed before entering
into the data warehouse. You need to clean and process the
data before putting it into a warehouse. Cleansing means
removing extra spaces, deleting null values from primary
key columns, etc.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are the design methods of data warehousing?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is surrogate key? Where we use it? Explain with examples.
What is Discrete and Continuous data in Data mining world?
Explain about core dimension, balanced dimension, and dirty dimension?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What is a functional dependency f said to be minimal?
Explain the difference between dw and bi?
What is the difference between connected and unconnected stored procedures?
What is factless fact tables?
Explain datawarehousing?
What is a source qualifier?
How can we run the graph? How can we schedule the graph in unix?
Compare and contrast aggregates & indexes
Explain what is the advantages data mining over traditional approaches?