Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the function of surrogate key in data warehousing?
Explain how to generate iqd file from framework manager?
How did you plan your Data ware house project?
What do you mean by static and local variable?
What is data analytics in simple terms?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain meta data?
What is load manager?
Explain what are non-additive facts in detail?
What is Star Schema?
Explain the difference between filter and conditin?
Explain what is ods (operation data source)?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
