SQL - PL/SQL

random_rows.psql - selecting a sample set of random rows from a table. Useful for spot checking the contents.

PL/SQL Sample 1 - update one table with information from another, parsing the smaller table for data to update into the parent table.

PL/SQL Sample 2 - Process multiple rows for a PK accumulating data in a concatenated string, and then add to a parent table.

PL/SQL Sample 3 - populate fact table to report multiple event dates on a single calendar axis. This example parses a table with projects, one per row, and inserts into the fact table using a single date key, and one fact column per project date.

MicroStrategy

restart_iserver.sh - a shell script to shutdown and re-start intelligence server - tested for AIX.

load_tree.plx - migrate a PeopleSoft tree to a denormalized table (DIM table) for MSTR or other BI tool reporting.