We have an urgent requirement for BI Architech @ Rochester, NY. Duration : 4 Weeks. Rate : $/hr + Exp.
Scope of Tasks:
Details: Work with team to assist in tuning Analytics.
The candidate must have the following 11g experience:
Data Warehouse 11g DBA with experience using and optimizing SQL Aggregations features of the 11g database.
Experience designing, implementing and tuning the Cube, Rollup and groping set features.
Aggregation is a fundamental part of data warehousing. To improve aggregation performance in your warehouse, Oracle Database provides the following functionality:
- CUBE and ROLLUP extensions to the GROUP BY clause
- Three GROUPING functions
- GROUPING SETS expression
- Pivoting operations
Experience implementing the CUBE feature to do efficient analysis across multiple dimensions without performing a CUBE operation.
Computing a CUBE creates a heavy processing load, so replacing cubes with grouping sets can significantly increase performance.
Thanks & Regards,
John Dennis. N