Posted: Mon Feb 11, 2013 8:33 am Post subject: Re: Data Warehouse for Ellucian Banner
ODS is an option but wondering what others have done?
I would build the data warehouse, performance will be poor if you just map a universe over an ODS. It will also deteriorate over time as you have more data within the ODS structure.
Warehouses / star schemas on the other hand can be partitioned over time and are structures designed for query optimisation.
Also wondering what are options for Dashboards and WEBI without a data warehouse.
Dashboards require highly aggregated data sets, so you would ideally require aggregates for these. Webi reports also perform better with aggregates also. _________________ Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.
Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."