Skip to main content

Informatica

Group of web developers working in an office.

Feature of Snowflake: Zero Copy Cloning

                                                                      Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]

tiethnic colleagues sitting at desk looking at laptop computer in office. stock photo

How to Convert Blank Values to Null in Flat File Source in SSIS Package

SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]

Istock 498323425

How to Implement Indirect File Load in Informatica PowerCenter

Informatica PowerCenter is an ETL tool which is used to extract data from source and apply some transformation rules on the source data and load it to the target system. Informatica indirect file load is an option used to load the data from multiple source files that have similar structure and properties. The integration service […]

Multi State Integrated Health Network

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

Istock 648272290 Featured Image

Master Data Management: Modern Use Cases for Healthcare

Your organization may face data challenges as you work through ongoing consolidation and a flood of data from new sources. Master data is the cement that bonds your data foundation.  Healthcare leaders are prioritizing an enterprise view and catalogs that contain true master data for patients, providers, or members. But they also want to master […]

Talend Data Integration Platform

Looping Multiple Tags in tXMLMAP Component using Talend

Are you looking for How to do looping in XML files? Then yes, you are at the right place to get more information regarding how to retrieve data from XML files with multiple tags to process/transform using one of the advanced component in Talend studio known as tXMLMap Component. Before going into actual concept of […]

Istock 636932704 (3)

Looping Simple XML Tags using tXMLMap in Talend

Are you looking for ‘How to do looping in XML files’? Then yes, you are at the right place to get more information regarding how to retrieve data from XML files with multiple tags to process/transform using one of the advanced component in Talend studio known as tXMLMap Component. Before going into actual concept of […]

Istock 871840512

Exception Management in Informatica Data Quality

Problem Statement: A Banking Service loads data from different data sources into the Customer address table. When establishing data quality controls, there are bad records and duplicate records in the tables. The bank wants a list of customers in Chicago, Illinois below-given table shows the example of bad records and duplicate records in the table. […]

Migrating to Informatica Intelligent Cloud Services

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

Shot Of Two Technicians Working Together In A Server Room

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

What COVID-19 has taught us about the value of data

Agile BI & Analytics is the Need of the Hour – Drive insights during Pandemic Uncertainty

In uncertain times like these its essential that we consider the disruption that is happening and take a nimble approach to help Organizations including my own by driving analytics and insights across the various Lines of Business. How can we take all the Public data that is available from John Hopkins, CDC, WHO and various […]

Informaticacloud New

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

Load More