Introduction
This article explains about how to validate an XML document with XSD schema. The validation is performed by checking whether the XML document is a well-formed one by programmatically using Java packages. Using Java transformation in Infomatica PowerCenter 8.6 we are validating the XML.
Issue
We are creating the XML using expression and hard coding [...]
From the category archives:
Informatica Way
Informatica PowerCenter extended its functionality to support the Java language from the version of 8.0. Informatica PowerCenter provides a simple programming interface to implement transformation functionality with java programming language.
Informatica PowerCenter facilitates the developers/users to import the java packages and use them to achieve specific business rule which defined in the java package. Looping of [...]
With 9x wave from Informatica hitting the market big, our long plans for Informatica Upgrade were focused on to 9.1.0 HotFix 2 (a recent release) for the PowerCenter edition. The EOL(end of life) notice from Informatica to end their standard support on 8x also made our decision to focus on the latest and greatest version [...]
Power Center lets you control commit and roll back transactions based on a set of rows that pass through a Transaction Control transformation. A transaction is the set of rows bound by commit or roll back rows. You can define a transaction based on a varying number of input rows. You might want to define [...]
Parameter file is a text file that contains parameters and variables which can be referenced in Sessions and Workflows. Multiple Session and Workflows can share the same parameter file by logically grouping the Parameter file as mentioned below.
Each section is preceded by a heading that identifies the Integration Service, Integration Service process, Workflow, Worklet or [...]
SQL Transformation is an Active/Passive & Connected transformation. Through SQL Transformation we can insert, delete, update, and retrieve rows from a database at run time. The transformation processes external SQL scripts or SQL queries created in an SQL editor and returns rows and database errors. Through the SQL transformation we can create the tables in [...]
Informatica Inbuilt Error Logging feature can be leveraged to implement Row Error logging in a central location. When a row error occurs, the Integration service logs error information which can be used to determine the cause and source of the error.
These errors can be logged either in a relational table or in a flat file. [...]
Informatica File Transfer Protocol can be used to transfer/move files from different environment into our pre-defined Landing Zone. It can also be used to transfer file to the destination folder/directories. The Integration Service can use FTP to access any machine it can connect to, including mainframes.
Configuring FTP in Informatica Workflow
To use FTP file sources and [...]
Informatica User Defined Functions are similar to Built-in Functions, where these functions need to be created once and execute multiple times. Transformation logics that are common across the ports are the ideal candidate for User Defined Functions.
Transformation Logic implemented without User Defined Functions
Validation “IIF( ISNULL(LTRIM(RTRIM(INPUT))),’TRUE’,’FALSE’)” is being performed in multiple ports.
The disadvantage with this approach [...]
What is Pushdown Optimization and things to consider
The process of pushing transformation logic to the source or target database by Informatica Integration service is known as Pushdown Optimization. When a session is configured to run for Pushdown Optimization, the Integration Service translates the transformation logic into SQL queries and sends the SQL queries to [...]
