Posts Tagged ‘data integration’

The Community Reinvestment Act (CRA) is a federal law in the US that promotes the interest of financial service firms to serve their communities’ credit needs, including low- and moderate-income neighborhoods. Federal banking agencies use the bank’s contribution metrics as a parameter when they apply for mergers, acquisitions, and new branch openings. CRA remains essential […]

Informatica World takes place May 8-11 at the Venetian Resort Las Vegas and we can’t wait to meet you there! Perficient is a proud sponsor of Informatica’s largest event, which brings together customers and partners from across the globe. Perficient is a global digital consultancy, an Informatica Platinum Enterprise Partner, and the 2022 Cloud Modernization […]

In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]

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

We’re pleased to announce that we’ve been presented the Talend US Partner of the Year award.  Talend, a global leader in cloud data integration and data integrity, revealed its Partner of the Year Awards, 2021, during the annual Partner Summit held virtually this year. The award recognizes Perficient’s “demonstrated exceptional innovation and leadership in advancing […]

On my most recent client engagement, I was tasked with importing data into OneStream. Data integrations are a strength of OneStream, and there are several methods to load data into the system. The four types of data integrations are: delimited file, fixed file, data management, or data connector. My client required flat file and direct […]

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

The following is the thirteenth blog in a series about why businesses are moving to the cloud to modernize and improve business performance. Throughout this series, we have discussed the many benefits of cloud, including increased velocity for innovation, enhanced security, and the opportunity for ROI. Now we want to discuss how the cloud can […]

MicroStrategy World 2020 is about a month away, happening February 4-6 in Orlando, FL. Sunny, warm weather and the latest MicroStrategy releases will make for an awesome and exciting, education-packed week. Perficient is proud to be a Silver sponsor of the event this year.  Our experts look forward to meeting you in the expo hall […]

MuleSoft’s Anypoint platform is a robust system to help both in creating and leveraging connections between separate systems. This can, in effect, create an “application network” where previously unconnected sources of data come together to meet your business’s needs. (By the way, if you’re not familiar with MuleSoft yet, you can learn more about the […]

I’ve said it before and I’ll say it again… it is impressively difficult to integrate data from one or more EMR systems into a cohesive analytical warehouse database. Especially if you’re doing it from scratch. In my last two blogs (Data Integration: Taming the Beast of Healthcare & Data Integration: Taming the Beast of Healthcare […]