CODEWITHSUNDEEP
asciiinformaticaebcdic
Agileskunk
Agileskunk

Reputation: 1

Informatica v10.2 - Transformation for ASCII to EBCDIC

I need to convert data from ASCII to EBCDIC in an Informatica Transformation. I have attempted to use CONVERT_BASE in an expression using string datatypes for the currency data, but received a non-fatal error.

I've also googled a fair amount and have been unable to find a solution.

Has anyone encountered and been successful in a situation like this?

Upvotes: 0

Views: 614

Answers (1)

Uday Mannam
Uday Mannam

Reputation: 31

In Complex Data Exchange, you do not require a transformer to convert ASCII to EBCDIC format.

To change the encoding from ASCII to EBCDIC format, do the following:

LaunchContentMaster Studio Go toProject > Properties > Encoding Change the output encoding toEBCDIC-37 and the byte order toBigEndian.

Just in case if you need to transfer flat file from mainframe (EBCDIC) to Linux (ASCII) and preserve packed decimal fields / COMP-3 (i.e. do not unpack COMP-3); You can use a combination of PWX for VSAM/Sequential on the mainframe source, and PWX for Flat Files on the Linux machine for the target.

Create appropriate datamaps for the source, and for the target. On the source side, use datamap functions to create a new field for each of the packed fields, as an unpacked value. In the mapping, bring in the unpacked value ports, not the packed ones, as numerics. In the datamap for the target, create only the packed fields. In the mapping, map the (unpacked) numerics to packed numerics fields

PWX should handle the conversions for you.

Note that this includes operations on packed fields, so some signs may get converted from F to C.

Upvotes: 0

Related Questions