Answer Posted / sowmi
DWH Architecture:
It has 3 layers:
1.Staging
2.Integration
3.Target
In staging we get the raw data.In integration we process i.e
we cleanse the data.In target the data is ready to be used
by end users for report generation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the advantages data mining over traditional approaches?
What are the different methods of loading dimension tables?
What is the difference between olap and datawarehosue?
Difference between PowerPlay transformer and power play reports?
Explain what is the difference between power center & power mart?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain reference cursor?
What are the various file formats involved in reportnet?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are the advantages of cold fusion?
What are the tools available for etl?
Explain the different types of data warehousing?
What are partition points?
Explain swot analysis?
