Data + Intelligence

Most of us know that the Informatica Normalizer transformation is being used to convert columns into multiple rows. But one of the limitations is that the occur clause in the Normalizer transformation is fixed for all the input rows from the source. For example, if the requirement is to generate n number of rows for […]

Cybersecurity is a hot topic across all industries, with most companies recognizing the importance of identifying and mitigating risk factors across IT environments. Recent news headlines have focused on external threats, but internal risks represent over $40 billion in losses annually. When developing an enterprise security plan, it’s important to account for common IT security […]

In my previous posts I discussed trends impacting governance. In my next few posts I will cover trends in governance – the first of which is Interest from Leadership. Governance is being discussed in the C-suite as a business imperative to the success and growth of a company. As the “Information as an Asset” takes […]

Big Data brings its own challenges to the governance practice. Governing massive quantities of information that move quickly in and out of the enterprise requires a robust and nimble governance program. Governance practitioners must adjust their thinking and approach to deal with this while still maintaining the integrity and control of the information that is […]

(What is it?) Mapping Architect for Visio is an Informatica power center client which is used to create mapping templates using Microsoft office Visio. (Why?) Mapping templates created using Visio work  as a sketch of PowerCenter mapping which offers reliability and improves efficiency in: Defining principles or rules that determines how specific procedures or methods can […]

There are 4 major shifts in the market for data integration: Moving from a massive enterprise data warehouse to Hadoop for cost savings Moving from enterprise data models to data lake architecture for a quick time-to-value when on-boarding new data Hybrid on-premises/cloud approaches including a variety of enterprise SaaS applications Real-time streaming analytics and self-service […]

The need exists for the ability to read and extract data from BICS, especially when the ETL strategy involves a Staging approach, as written about in Best Practice to ETL with Data Sync (BICS). But Data Sync does not support the direct data read from BICS. The built-in Oracle (BICS) connection in Data Sync only supports a data write to BICS. […]

Similarly to recognizing information is different than data, the idea that information is an asset is gaining more traction. Organizations are seeing that information not only powers internal processes, but that the information itself has value, whether in defining new products or services, improving consumer experience or even outright selling, either directly or through providing […]

Cost reduction remains a priority among financial institutions. Aside from re-negotiating contracts with vendors, consolidating IT applications is an ongoing trend in the industry. When speaking on the topic of expense reductions, Ralph W. Babb, chairman and CEO of Comerica, said, “We will enhance our technology capabilities, while reducing our overall spend by optimizing our […]

A couple weeks ago, Oracle released Oracle Analytics Cloud (OAC). But there was already Oracle Cloud offerings for BI, mainly Business Intelligence Cloud Service (BICS) and Data Visualization Cloud Service (DVCS), so why is this new? And how is it different? Simply, OAC doesn’t abolish its predecessor Cloud BI services, but it makes them more […]

Information Governance is beginning to pop-up and position itself as different – but related – to Data Governance. Generally, the healthcare industry is seeing Information Governance more as a strategic endeavor, while Data Governance is more tactical in nature. However, it really seems to be about providing a more business focus on the governance initiative. […]

Common dimensions are required for cross-facts reporting, and are oftentimes referred to as conformed dimensions. A dimension can be conformed through its data consolidation, or its logical data model. Data consolidation is useful for conforming the dimension data which has the same hierarchy level, and happens in MDM and ETL processes. A logical dimension is very useful for conforming the […]