Informatica - Java Transformation

This article explains the use of Java Transformation with an example. We have input data as below. And need to transform data in such a way that it creates 5 different records with EMI Sequence Number, due date and the outstanding or balance loan amount. This transformation can be active or passive. When we think about transforming single record to multiple records, the first transformation comes to our mind is Normalizer...

Read More

Informatica - Error: FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Inconsistent descriptor information.

This article tries to find solution for the below error scenario in Informatica. Error Message: WRT_8229    Database errors occurred: FnName: Execute -- [Informatica][ODBC SQL Server Wire Protocol driver]Inconsistent descriptor information. FnName: Execute -- [DataDirect][ODBC lib] Function sequence error Error Scenario: When SMALLDATETIME column from source is moved to SMALLDATETIME column at target, all...

Read More

Informatica - Normalizer Transformation Example

This article explains the use of Normalizer Transformation with an example. We have source data as below. And want output as below. Normalizer Transformation: In this example, There are 4 different expense columns and it needs to be normalized. So define the output ports in the "Normalizer Tab" and set the "Occurs" to 4, since we have 4 columns to be normalized. Expression Transformation: The "GK_" column (1, 2, 3, 4.....)...

Read More

Informatica - Splitting a Flat File based on a column using Transaction Control

This article explains how to split records based on a particular column into multiple flat files using Transaction Control Transformation. Below given the Mapping and transformation Snapshots. Mapping Snapshot Sorter Transformation: Sorts the records based on column that used to split the file. In this example, it is JOB column. Expression Transformation: After sorting based on JOB column. The first job column will be marked as '1'...

Read More

MySQL - String Functions

Hi Everyone, Here are the some of the string functions in MySQL . Before we start we should keep below points in mind. String functions return NULL, if the length of the result would be greater than the value of the max_allowed_packet system variable. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, non-integer arguments are rounded to the nearest integer. ...

Read More