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 are the approaches used by optimizer during execution plan?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are algorithms provided by Microsoft in SQL Server?
What is data cleaning? How can we do that?
What are the various tools? Explain name a few?
Explain a linked cube?
What is static and local variable?
Explain what are the different methods of loading dimension tables?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Can we start and stop single session in concurent bstch?
What are diagrams?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are the various transformation available?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
