Informatica – Importing Fixed Width Flat Files — Fixed-width flat files are byte-oriented (measured in bytes). — It can also be line sequential, which means each row ends with a newline character. — Use Flat File Wizard to create, move, or delete column breaks. — ‘Start Import At Row’ Indicates the row number at which… Continue reading Informatica – Working with Fixed Width Flat Files
Category: Informatica PowerCenter
TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points
TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points. Your session may fail with this error while doing aggregator transformation with ‘Sorted Input’ enabled. This is not a data Issue but a configuration Issue. We need to add a custom property (AggSupprtWithNoPartLic = YES) in the PowerCenter integration service to… Continue reading TM_6281 ERROR: Partitioning option license required to run sessions with user defined partition points
How to concatenate the first and last name – Expression Transformation
Informatica – How to concatenate the first and last name – Expression Transformation Using expression transformation we can combine two strings to a single string and load to target. Here we are going to concatenate First Name & Last name and storing to a new column in target as Full Name using CONCAT function in… Continue reading How to concatenate the first and last name – Expression Transformation
PCSF_46008 Cannot connect to domain to lookup service – Informatica power center
You may experience this error while trying to connect to PowerCenter developer tools like Repository Manager, Designer, workflow Manager or workflow monitor. This error might be due to below two possible scenarios. Your informatica service is not running your database connection password might have expired Here is the steps to follow to make sure… Continue reading PCSF_46008 Cannot connect to domain to lookup service – Informatica power center
PowerCenter Express Overview
PowerCenter Express Overview — Its a single unified enterprise data integration platform. — Use PowerCenter Express to design and implement data integration solutions. — Use it to extract data from multiple sources, transform the data according to business logic, and load the transformed data to targets. (ETL) — PowerCenter Express includes the Informatica domain, clients, server and… Continue reading PowerCenter Express Overview
Informatica Transformations – Types
Types of Transformations A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Transformations in a mapping represent the operations the Integration Service performs on the data. Transformations can be of the… Continue reading Informatica Transformations – Types
Informatica Transformations – Overview
Transformation Overview A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. Transformations in a mapping represent the operations the Integration Service performs on the data. Transformations can be active or passive. Transformations can be connected to the data flow, or they… Continue reading Informatica Transformations – Overview