There are two kinds of definitions relevant to data warehouse design - (1) definition of business terms (2) definition of data elements. ...
Read More
Showing posts with label Database Technologies. Show all posts
DB2 Tuning - Sample DB2 Reorg and Run stats commands
If anyone is looking for a quick cheat sheet for DB2 areorg and subsequent runstat, below is a very useful and concise explanation with exa...
Read More
Sample DB2 Database Configuration
Here is a tuned Database configuration for a heavily loaded workflow application - [db2inst1@intranet db2inst1]$ db2 get db cfg for wf ...
Read More
Sample PL/SQL script for cleaning a detail table referring a mastertable
Have you ever had a need to write a PL/SQL snippet to clean a table. If you are in need, here is one below - Here is a sample PL/SQL code t...
Read More
Newton Raphson Method
Newton Raphson method is the core in computer Numerical analysis software programs to find root of euqations such as e<sup>-x</sup...
Read More
Subscribe to:
Posts (Atom)