Subscribe: Faster, Bigger, Better - Data Integration
Preview: Faster, Bigger, Better - Data Integration

Faster, Bigger, Better - Data Integration

Everything about large data warehouse, metadata integration, high-performance ETL, OLAP, emerging BI technology, and appliance-based solution. All the views expressed here are based on my own practice and opinions, and do not reflect the views of any of

Published: Thu, 23 Nov 2017 23:05:32 +0000


Oracle SQL Developer - connections.xml

Fri, 04 Mar 2011 13:48:04 GMT

Sometimes, upgrading Oracle SQL Developer might not import your existing connections. You need to copy the connections.xml file from your previous version.

Windows XP hangs at isapnp.sys

Tue, 06 Apr 2010 01:52:13 GMT

Suddenly my Windows XP can't boot up. It went to black screen in normal mode, or hang after loading isapnp.sys in safe mode. It turns out that a virus put a 0-size ****.sys file in Windows\system32\drivers folder. I had to boot up from Hiren's Boot CD, and deleted such 0-size file. Then Windows XP came back to life.

Some thoughts after MicroStrategy Symposium

Fri, 11 Sep 2009 17:15:13 GMT

Scratch the surface of MicroStrategy in-memory cube, multisource pushdown option. Pay attention to the trend that ROLAP marries MOLAP for better balance of performance and data availability.

Video - Informatica PowerCenter Installation/Upgrade

Sun, 24 May 2009 23:35:09 GMT

Video about Informatica PowerCenter, MicroStrategy, Microsoft BI, SAP

HOW TO: Link FI Doc Item to the MM Doc Item

Tue, 30 Dec 2008 13:15:38 GMT

When a MM item is generated, there will be corresponding FI items posted in R/3 as well. However, there is no directly link between BSEG and MSEG. Here is a way to link BSEG to MSEG...

Dig into Informatica PowerCenter Repository

Mon, 29 Dec 2008 11:22:17 GMT

PowerCenter Repository is full of handy metadata to make the development or migration easier. Here are some useful samples.

What is the better partition strategy for big dimension tables in data warehouse?

Wed, 19 Nov 2008 20:10:41 GMT

DW architect like R. Kimball recommended that the SCD2 dimension should contain less than 1,000,000 rows, thus star schema makes more sense than snow flake. But we are dealing with big dimensions such as customer, product, service, account, ... which can easily grow beyond 50,000,000 or even 200,000,000 rows. We need to figure out a better physical model to address such challenge.

How to generate and merge PowerCenter parameter files for better parametrization

Sun, 26 Oct 2008 19:03:51 GMT

This article discusses the approach to use dynamically generated parameter files to make ETL more metadata-driven or data-driven

UNIX script to monitor the [pmdtm] sessions

Thu, 12 Jun 2008 14:42:48 GMT

Use special UNIX command provided by Solaris/AIX to find out the most CPU-consuming Informatica PowerCenter sessions.

Informatica World 2008 - What's New and What's Cool

Mon, 09 Jun 2008 22:45:24 GMT

Informatica demonstrated its next version of unified data integration platform at Las Vegas last week. Version 8.6 comes along with many exciting features, such as real-time, data quality, on-demand, web service, and ease of use.

Best Practice: Upgrade to PowerCenter 8.5.x and 8.6.x

Wed, 16 Apr 2008 21:53:50 GMT

How to reduce the risk of Informatica PowerCenter Upgrade Project? Here are some Tips and Myth.

A Tiny Perl Script to Help Tune Lookup Cache Performance

Mon, 26 Nov 2007 23:20:31 GMT

A lot of times, the developers don't know how to configure the buffer memory for Informatica lookup cache. The calculation formula provided by Informatica is accurate but hard to use. Here is the script which may make the tuning much easier.

PowerCenter Repository Code Page ID

Wed, 21 Nov 2007 23:19:34 GMT

Code Page Issue and Resolution during Informatica PowerCenter 8.x Installation and Upgrade

OS Choice for ETL Solution: Window, Solaris, AIX, HP-UX, or Linux

Fri, 28 Sep 2007 20:08:22 GMT

Should the data integration solution rely purely on the single platform in your company? What's the good side for fixing infrastructure of both Windows and UNIX?

64-bit Data Integration Tool Consideration

Fri, 28 Sep 2007 19:07:37 GMT

Is 64-bit the holy grail to resolve most of our performance issues in data integration? Find out the truth here...