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 [...]

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. [...]

Load More Posts