When working with datasets in Excel, you might encounter situations where multiple values are stored in a single cell, separated by a newline character (added using Alt + Enter). This can make data analysis challenging. In this blog, we’ll walk you through how to split such data into separate rows using Power Query, a powerful […]
Mohammed Salem Basha Shaik
Mohammed Salem Basha Shaik works at Perficient as a Technical Consultant. He has a firm understanding of technologies like Informatica PowerCenter & Informatica IICS. He is keen to learn about new technologies.
Blogs from this Author
Understanding In-Out and Input Parameters in IICS
In Informatica Intelligent Cloud Services (IICS), In-Out and Input Parameters provide flexibility in managing dynamic values for your mappings. This allows you to avoid hard-coding values directly into the mapping and instead configure them externally through parameter files, ensuring ease of maintenance, especially in production environments. Below, we’ll walk through the concepts and how to […]
IICS Micro and Macro Services
Macros in IICS Informatica IICS: An expression macro is a useful technique for creating complex or repeating expressions in mappings. This makes it possible to perform computations over various fields or constants. creating a collection of related expressions so that the same computation can be done on several input fields. Steps to Use […]