I'm a Manager of several developers using various Cognos/data warehouse tools. I have no intimate training or familiarity with the tool and apologize in advance for my admitted ignorance.
Can a developer who's had training in Framework Manager and has access to the tool, create dimensions, facts, etc... within the Framework Management tool, but no authorization or training within Data Manager?
Hi,
They would be able to use Framework Manager to create metadata definitions which emulate dimension tables and fact tables, but would not be able to create or populate physical dimension and fact tables in a database.
Data Manager is an ETL tool - ie it physically extracts, transforms and loads data into real tables in a data warehouse - usually these are dimension and fact tables. Framework Manager is a metadata modelling tool, used to build reporting packages, so any design work done does not affect physical data storage.
Hope that helps! :)
MF.
Thanks. This does help. So I'm assuming that the physical creation of the dimension, facts, etc...is created via too such as SQl server and the population transformation of the data into the physical table is done by data manager?
Data Manager will create the tables it writes to if they don't already exist. Sometimes DBAs will not allow this, and insist on creating the tables manually, but otherwise Data Manager is used to both create and populate tables.
Regards,
MF.
Snet form my fumblefingers
iPhon 5 usig Tapatalk
In my experience (at least with larger companies) there is a clear distinction between responsibilities of the BI/ETL developer and the DBA. Even if the ETL tool can generate the resulting target tables it would be proper to assign this to the DBA. They are responsible for database maintenance and you will find them generally much more cooperative if they are involved in the process..