Data Warehousing

Real Time Operational Business Intelligence with GoldenGate

Posted by on September 1, 2013 at 5:00 pm

Oracle Corporation’ (ORCL) acquisition of Golden Gate Software on July of 2009 was a big step for Oracle in its quest to build a open and heterogeneous product line that will be more appealing to enterprise customers with complex OLTP and data warehouse environments. You can find a detailed presentation of the considerations that were […]

Informatica being replaced by ODI in Oracle BI Apps

Posted by on August 1, 2013 at 6:00 pm

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed […]

Sunopsis seven years after it’s acquisition

Posted by on January 15, 2013 at 10:00 pm

On October of 2006 Oracle acquired Sunopsisa sofware company whose flagship product was one of the up-and-coming players in the datata warehousing arena. Sunopsis for easy integration in environments with multiple database systems and differentiated itself by adopting an Extract-Load-Transform architecture that decreased the learning curve for database developers that were immediately able to create […]

Materialized View Maintenance – Part I: Guidelines

Posted by on January 15, 2011 at 6:00 pm

I have been working with a lot of materialized views in our PeopleSoft Campus Solutions Warehouse lately and let me tell you, they can be a pain some times. Before I go into technical details here are some best practices that we have developed in our environment for data that is loaded once nightly.

Configure your database to host your Informatica Repository (Oracle 11g)

Posted by on September 16, 2010 at 6:00 pm

The Informatica repository is designed to reside in a database system, for my local test environment I will be hosting it in an Oracle 11g database. Here are two design principles that need to be taken into consideration when setting up the database that will host your repository: Creating a dedicated tablespace for your repository […]

PeopleSoft EPM Dimension NULL records

Posted by on June 11, 2010 at 6:00 pm

How to handle cases where configuration tables like PS_GVT_POI_TBL or other feature sets that don’t apply to your company are not being implemented. In many cases complete dimensions will be empty and look-ups in fact jobs will fail.

PeopleSoft Enterprise Performance Management Warehouse Schema Naming Standards

Posted by on June 2, 2010 at 6:00 pm

The nicest thing about PeopleSoft after the whole PIA Metadata-driven interface and its impact on data quality is how meticulous PeopleSoft engineers are about documentation and sticking to naming standards, here’s a simplified diagram of the wharehouse architecture and the naming standard for objects in each section of the schema:

DataStage: ParamName does not reference a known parameter of the job

Posted by on May 26, 2010 at 6:00 pm

Today I got an error that reads like this: JobControl (@<JOB_NAME>): Controller problem: Error calling DSSetParam($<PARAMETER_NAME>), code=-3 [ParamName does not reference a known parameter of the job] After a quick debug/issue tracking session on Director I found out that one of the jobs in my master sequence was missing all of our standard parameters with […]

Abnormal termination of stage (cast those CLOBs!)

Posted by on May 25, 2010 at 6:00 pm

Abnormal termination of stage (cast those CLOBs!)

EPM Integration Updates

Posted by on March 25, 2010 at 6:00 pm

In order to move PeopleSoft HRMS9.0 data into EPM9.0 your team will need to deploy the ETL “Integration Update” for HRMS9.0 (HRMS=HCM). IU jobs need to be deployed to a separate project if you are running on linux.

Leverage PeopleSoft EPM Data Lineage Spreadsheets

Posted by on February 28, 2010 at 6:00 pm

Not having to do all the leg work necessary to arrive at table-level data lineage in the PeopleSoft EPM Warehouse is a great testimony to good documentation and a great culture back there at big PS….

PeopleSoft EPM:Applying Maintenance Packs and Bundles (Updates)

Posted by on January 30, 2010 at 8:00 am

We had one or two issues related to DataStage ETL maps that were skipped when we applied MP5 and multiple bundles on our development environment.  To prevent this issue from happening again I decided to re-install all of our ETL maps from scratch using a Sharepoint wiki to keep track of the update level applied […]

Don’t go too fast about rolling out your EPM 9.0 OWS jobs if your source system is HCM 9.0

Posted by on January 10, 2010 at 6:00 pm

Peoplesoft EPM ETL Configuration