Billing and Revenue Management

Create testnap scripts for BRM using SQL queries

In this blog, we’ll learn how to create testnap scripts using SQL queries. Before we dive in, it might be a good idea to brush up on the following topics unless you’re already an expert: SQL query … Read More »

More Posts from this Category

Data Management

The key principles to MDM success

As I ride back to Philadelphia, I can’t help but think of the day’s events at Informatica MDM Day 2015 in New York City. The day was rich with keynotes and panels from customers, partners and … Read More »

More Posts from this Category »

The Intersection

The key principles to MDM success

As I ride back to Philadelphia, I can’t help but think of the day’s events at Informatica MDM Day 2015 in New York City. The day was rich with keynotes and panels from customers, partners and Informatica, all sharing a variety of experiences with their Master Data Management implementations. Unsurprisingly, despite coming from various industries, like finance, banking and healthcare, nearly all … Read More »

Create testnap scripts for BRM using SQL queries

In this blog, we’ll learn how to create testnap scripts using SQL queries. Before we dive in, it might be a good idea to brush up on the following topics unless you’re already an expert: SQL query understanding, including SQLPLUS Basic BRM knowledge, including using testnap (editing/executing scripts) Basic Query Let's start with the basics. Suppose you run the following simple query … Read More »

Data security for your company. Seriously. It’s time.

Another day, another data security breach. I keep hearing companies say that they need to get smarter and protect their data but the truth is that a majority are moving too slowly or not at all. Every single company houses sensitive data. It might be on-site, on a hosted server or in the cloud but it all needs to be considered for your enterprise data security plan. Anthem just had 80 million … Read More »

Implementing a Type 2 Slowly Changing Dimension Solution in Informatica PowerCenter

A slowly changing dimension is a common occurrence in data warehousing. In general, this applies to any case where an attribute for a dimension record varies over time. There are three typical solutions for this. In the first, or type 1, the new record replaces the old record and history is lost. The second, or type 2, a new record is added into the customer dimension table and the customer is … Read More »