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
Which columns go to the fact table and which columns go the dimension table?
Explain how to generate iqd file from framework manager?
How much data hold in one universe.
Whether dimension table can have numeric value?
What are templates in which way it is help full?
What are Aggregate tables?
What is the difference between Datawarehouse and OLAP?
How can you clear the cache?
What is edw?
What is the very basic difference between data warehouse and operational databases?
What is scd1 , scd2 , scd3?
Why we use repository connectivity?
Explain the main differences between star and snowflake schema?
What are the methodologies of data warehousing?
What is the difference between power center and power mart?