This is part 2 of the Transformation and Cleanse videos. In my first video I went over the basics of the window, how to access and process data. In this video I will go over most of the rules. The...
In Toad Data Point 3.7 we have rewritten the Transformation and Cleanse window. This new window now includes data profiling information, many more transformation rules and a robust engine for processi...
In this article series, we are discussing Oracle Real User Experience Insight. Part I was here. This is the second article in the series. We discussed the RUEI installation requirements and other mat...
In many organizations, the IT department and its administrators monitor the performance of the database servers, databases, web servers and application servers. They are happy when these are working n...
In my last blog titled “Varying Database Benchmark Results” I tried to explain why people can often get varied performance results when running a specific database benchmark multiple times. I attempte...
I’ve been asked on numerous occasions why do peoples’ database benchmark results often vary. In other words why one observed transaction per second (TPS) value today and sometimes 20% or more off tomo...
Database Modeling Support for three different types of models: Logical model with support for inheritance. Universal model (Generic physical model). Physical model (+40 platforms) with Logical/Physi...
Introduction This article explains how to configure Business Intelligence publisher report with Cloud Control 12.1.0.4, why business intelligence report necessary when the information publisher report...
Here is part of a case study that I would like to share with our users: "This enterprise data system is part of what makes Haas a leading global provider of chemical supply chain management(CSCM) sol...
The SQL Tuning Problem If you ask most DBA's what their #1 pain point is the likely response would be database performance issues. The quickest and least expensive way to solve database performance i...
This video shows how to build accurate schema deployment scripts with Toad for Oracle Xpert Edition....
This video shows how to auto-optimize SQL code with Toad for Oracle Xpert Edition....
