Optimal Mapping Design – Pedro Carvalho

Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)

I highly recommend reading the first three links on References, at the end of this post. About XML What says the official documentation: “Each group in an XML source definition is analogous to a relational table, and the Designer treats each group within the XML Source Qualifier transformation as a separate source of data.” TheContinue reading “Informatica Powercenter – XML Transformation (XML Source Qualifier, XML Parser, XML Generator)”

Informatica Powercenter – Stored Procedure Transformation

Let’s start checking out what the official documentation has to say: “A Stored Procedure transformation is an important tool for populating and maintaining databases. Database administrators create stored procedures to automate tasks that are too complicated for standard SQL statements. The Stored Procedure transformation is a passive transformation. You can configure a connected or unconnectedContinue reading “Informatica Powercenter – Stored Procedure Transformation”

Informatica Powercenter – SQL Overrides

I did not really find any super good resource on this topic, but the overall idea of SQL override is to override a transformation default behavior by writing a SQL query instead. Of course, SQL overrides works only on relational data. There is no SQL Overrides for flat file. For instance, take a source qualifierContinue reading “Informatica Powercenter – SQL Overrides”