Informatica

Everything is data and everyone is data! Everybody says we live in the technology age, the age of the internet, the age of space and cosmos, the age of the digital world etc. But all of these developments and advancements have been made possible by the Holy Grail called Data. We learned how to store […]

As mentioned last week, Perficient was a proud sponsor of this year’s Informatica World conference. We met with many Informatica customers and companies evaluating the suite of products. The event was also a great opportunity to hear from other thought leaders in the areas of Big Data, MDM, and cloud. It was clear from Informatica […]

Informatica World 2017 is underway and we’re excited to sponsor this year’s event. This event is the premier user conference for Informatica, covering Big Data, master data management, cloud integration, next generation data strategies, and more. Attendees are learning the latest in Informatica product roadmaps, technical deep dives, and roundtable sessions. In addition to terrific […]

With the new release of Informatica’s iPaaS offering they add API management capabilities to the industry leading cloud data integration and synchronization platform. They also strengthened their on-premises agent to improve throughput and availability by adding load balancing and clustering. API management is a significant new Informatica capability. With API Management users can API-enable data […]

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

(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 […]

I recently implemented an Informatica Lifecycle Management (ILM) project at a national auto financing company and I would like to share some details about what I learned about ILM and the benefits my client received.  ILM is a mature and robust data archiving tool used by many organizations to manage and archive large sets of […]

In my last blog, I presented a brief overview on Informatica Data Quality (IDQ) tools, the significance of Data Profiling and how to use the Analyst tool to profile data. In this second blog, I will introduce a few commonly used Informatica Developer tool Data Transformations. But, Why Data Transformations? Long story short, Data Quality […]

Whether your organization is currently evaluating cloud platforms and primarily storing data on-premises or you’ve made the journey to cloud and are adopting a hybrid model, accurate and timely access to data should be a focus. Regardless of where you are on your cloud journey, a flexible data management platform helps you to deliver what […]

Many of us have used the looping logic in programming languages or in others tool that we use. Looping logic is when you process each record continuously until it reaches its maximum limit. So, what’s new in looping logic? Let’s see here. In Informatica, it is quite problematic to loop a single record and there […]

Data analytics, Master data management has been a top trending Business Intelligence implementation in last couple of years. One of the key success criteria for these programs is to maintain good quality data. Businesses also demand more value from the data that is maintained in the enterprise data repository. So there is a strong emphasis to […]

Introduction In today’s fast paced world, Organizations have started using different types of software systems to compete and to be up to the speed of the world. This eventually increases the need for communication between different software systems and the same is growing by leaps and bounds. And with the Current data warehousing and data […]