Feature of Snowflake: Zero-Copy Cloning Zero Copy Cloning in Snowflake: Snowflakes have some advanced feature like Time Travel, zero-copy cloning […]
Informatica
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]
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, […]