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 […]
Posts Tagged ‘data integration’
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 […]
Perficient Named Talend US Partner of the Year
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 […]
Configure Flat File Data Integrations in OneStream
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 […]
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 […]
Integrating Data in the Cloud For Better Care
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 […]
Join Us at MicroStrategy World 2020
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 […]
How to Get the Most out of MuleSoft’s Anypoint Platform
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 […]
Data Integration: Taming the Beast of Healthcare – Part 3
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 […]
Data Integration: Taming the Beast of Healthcare – Part 2
Last September I started a blog series on data integration for Healthcare. The problem, it is impressively difficult to integrate data from one or more EMR systems into a cohesive analytical database. The fact that I’ve been doing that job for the last 2 months is a testament to that statement since it kept me […]
Connecting Customer Data: Prioritize For a 360° View
It’s no secret that understanding exactly who your customers are, including how and when they interact with your brand, is the most critical aspect of your business. Being present during the crucial touchpoints of a customer experience is rapidly becoming table stakes to acquiring and engaging your target market. Having the necessary data at your […]