Interested to Buy Any Domain ? << Click Here >> for more details...
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 load manager?
Where the applications and where ware house management system is used?
How can we determine what records to extract?
What are the data marts?
What is dimension modeling?
What are the various tools? Explain name a few?
What is the difference between star and snowflake schemas?
What are Non-additive facts?
What are the types of dimensional modeling?
What are aggregate tables and aggregate fact tables?
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.
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 meetthe condition.
What a static and local variable?
What is many-to-many dimensional model in datawarehousing ?
Explain what are the advantages of query studio compared to report studio?
