Posts Tagged ‘Informatica’

what is ETL? ETL is a process that extracts the data from different source systems, then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. The full form of ETL is Extract, Transform, and Load. What is a data warehouse (DW)? A Data Warehouse (DW) is […]

What is a Slowly Changing Dimension? A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Type 1 SCDs – Overwriting In […]

Quite often, while building the Data Integration Pipeline, Performance is a critical factor. The factors below are vital for following the guidelines while working on ETL processing with Informatica PowerCenter. The following items are to be considered during ETL DEV: Pre-Requisite Checks and Analysis Basic Tuning Guidelines Additional Tuning Practices Tuning Approach Pre-Requisite Checks/Analysis  Before […]

At Perficient, our people are at the heart of what we do. We love what we do and where we work, contributing to our collaborative, open, and friendly culture. Our culture is one of the main reasons Perficient continues to be recognized as a “Top Workplace” in key markets across the U.S. Perficient invests in […]

At Perficient, it’s our people who make a difference, and we’re excited to introduce the newest addition to our team. Meet OneStream and Informatica Partner Alliance Manager, Juliette Collins! With over twenty years of sales and relationship management experience, Juliette is using her expertise to build meaningful bonds and drive even bigger, better Perficient partnerships. […]

The Challenge in Supply Chain Let’s face it. You and your suppliers are linked together and what they do affects you. So if your supplier data is fragmented across dozens or even hundreds of systems, it’s probably costing you. What is causing these supply chain leaks? Data stored in various places like supply chain management […]

Does this sound familiar: you’re running multiple point-of-care systems, each with redundant data points collected. But what happens when there are small variations in how data is captured and processed across these systems? As a healthcare provider client of ours discovered, inconsistent data can reduce revenue realization. It caused claims to be improperly matched and […]

The Covid-19 pandemic has accelerated multicloud adoption and research predicts that workloads primarily executed in cloud-based external environments will increase from 36% in 2020 to 63% in 2022. Taking a cloud or multicloud approach has many benefits like reducing vendor lock-in, greater agility, scalability, network performance improvement, improved risk management, and more. But a multicloud environment […]

Informatica Intelligent Cloud Services (IICS) now offers a free command line utility that can be used to integrate your ETL jobs into most enterprise release management pipelines. It’s called the Asset Management command line interface (CLI). Version two now allows you to extract an IICS job into a single compressed file. Moving a single standalone […]

Introduction There was a time in a not so distant past, shopping means, it was all about planning which weekend to go, and in the name of shopping, people spend at least 3 to 4 hours minimum which includes going to restaurants as well. But now, Amazon and Flipkart are what we think about shopping, […]

As we move into the modern cloud data architecture era, enterprises are deploying 2 primary classes of data integration tools to handle the traditional ETL and ELT use cases. The first type of Data integration tool is GUI-Based Data Integration solutions. Talend, Infosphere Datastage, Informatica, and Matillion are good examples. These tools leverage a UI […]

Recently, at Informatica World 2019, I heard the importance of data platform in building AI capabilities for the organization. What is interesting is that Informatica, known for their products delivering the “Switzerland of Data”, is now using AI capabilities to enhance their own suite of products with CLAIRE capabilities. In further exploring a few other […]