| |
GeekInterview.com > Interview Questions > Data Warehousing > Reportnet
| Print | |
Question: Structure your Framework Manager
Answer: How would you structure your Framework Manager Model?
Would you structure into different layers?
If you would structure what would be the layers like and what each of them would signify? |
| June 06, 2008 03:00:57 |
#1 |
| Sandeep Bhavan P |
Database Expert Member Since: March 2006 Total Comments: 4 |
RE: Structure your Framework Manager
|
A model is normally structured into two layers/views. Database/ Physical view and Business/ Presentation view. These can be implemented using Namespaces.
You import the metadata into Physical layer from DB using data source connection. You will use Import Metadata Wizard. You will change the Query Subjects & Query Items, create relationships (joins) and other activities here.
In the Presentation layer, you create Query Subjects taking input from the existing Physical layer. You change the names of the Query Items and other cosmetic modifications.
You can choose only the Presentation layer while creating the Packages and apply appropriate security settings. |
| |
Back To Question | |
