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 […]
Posts Tagged ‘Informatica’
Implementation of SCD type 1 in Informatica PowerCenter
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 […]
Performance Tuning Guidelines – Informatica PowerCenter
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 […]
Are You Looking for Your Next Career Move?
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 […]
New OneStream and Informatica Alliance Manager: Juliette Collins
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. […]
What is Supplier 360 and What Does It Look Like
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 […]
A MDM Success Story: Streamlining Claims Processing and Payments With Reliable, Centralized Data
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 […]
Why migrate from Informatica PowerCenter to Informatica Intelligent Cloud Services
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 […]
Bringing Informatica Intelligent Cloud Service into your Release Management Pipeline
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 […]
Implementation of Twitter Connector in Informatica Cloud
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, […]
Data Architecture: 2.5 Types of Modern Data Integration Tools
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 […]
How to Build a Winning Data Platform
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 […]