Load data from a comp3 file to informatica

Question

I have a Comp3 file as a source in my mapping. How do I load data in the target. The source defination has fixed length and the Code Page is '7-bit ASCII'. The data is not populated properly. Please help.

Answer 1

Your source is mainframe file which contains data in COMP3 datatype format.
You need to create a datamap in PowerExchange for your MF source. When you will create datamap, COMP3 datatype's compatible datatype will be seen in source structure like packed/unpacked. This will fetch you proper data.

Answer 2

It is unclear whether the source is in ASCII or you need the data in ASCII.

Either way, any non-text field is not a good way to pass data between ASCII/EBCDIC in either direction. Binary, packed-decimal and floating-point fields are neither ASCII nor EBCDIC, which are codes for representing bytes. So if going through a translation binary/packed-decimal/floating-point will be garbled (you can get lucky with a limited range of binary values).