Consuming RESTful Web Services

By | February 8, 2016|Categories: Business Intelligence|Tags: , |

Informatica PowerCenter Tips & Tricks Series (Read the previous trick, Rolling Sums & Averages Grouped By Key) Informatica provides both a Web Service Consumer transformation and an HTTP transformation that can access a remote [...]

Informatica PowerCenter Tips & Tricks

By | November 23, 2015|Categories: Business Intelligence|Tags: , |

Rolling Sums & Averages Grouped By Key Informatica provides two rolling transformations, MOVINGSUM and MOVINGAVG, which combine the last N rows’ values automatically. These transformations have three crucial limitations: The first N-1 rows [...]

Informatica Analyst: an Intuitive Interface to Data Warehouse Reference Tables

By | May 15, 2015|Categories: Business Intelligence, Quality Assurance|Tags: , , |

Co-opting Informatica Analyst for Reference Data Maintenance by Data Stewards At the most recent meeting of the Houston Informatica User Group, I gave a brief presentation on a non-standard use for the data quality tool [...]

A First Look at Informatica’s New PowerCenter Express

By | September 30, 2013|Categories: Business Intelligence|Tags: , |

Informatica unveiled their newest product in the PowerCenter line, the PowerCenter Express, at Informatica World this year (find Smartbridge’s experience of the convention here). The sales pitch is certainly catchy: Free PowerCenter! First I heard [...]

4 Ways to Optimize PowerCenter Mappings

By | July 1, 2013|Categories: Business Intelligence|Tags: , , |

Plenty of sources will tell you that this or that method is the best way to optimize an ETL. Seldom do they point out the downsides of it, and even rarer do they mention caveats. [...]

5 Revelations from Informatica World 2013

By | June 7, 2013|Categories: Business Intelligence|Tags: |

Informatica World 2013 (IW2013) is wrapping up today and my colleague and I have been here all week. This was my first time in attendance at the IW conference, a somewhat typical format [...]

Load More Posts