I'm working in PowerCenter Designer on a Cobol Mainframe VSAM sourcefile and need to know what values in Prec and Scale should I use to get a PIC S9(9)V99 COMP-3. A coworker mentioned Informatica recognizes it like PIC S9(9)V9(2) COMP-3, and so I had to defined the field with Prec 11 - Scale 2, and I did that, but once data gets loaded in Stage table in SQL, then some fields show strange symbols for some columns, and other columns show expected values.

I also tried adding an Expression transformation for dividing by 100 the resulting value gotten from the Normalizer, but it didn't work as expected either. Do you have any idea about how could it be handled? The ' pic s9(9)V99 COMP-3' is interpreted as follows: s -- signed. 9(9) nine number digits.

V the implied decimal point. 99 -- two numeric digits comp-3 -- packed decimal.

In informatica this would be ' prec 11 scale 2'. Cannot remember how you tell Power Center its packed decimal but I know you can. Packed Decimal: two decimal digits in each byte with a special sign character in the last nibble. So +123456 is stored as hexadecimal '0123456C'. ( +123.456 would be stored as exactly the same hex string -- you just have to know what the scale you are expecting!).

Informatica PowerExchange™ for VSAM Unlock Complex Data. Today’s IT organizations face growing demand for timely access to critical operational data stored in VSAM files on IBM zSeries mainframes. New business initiatives, such as improving customer service, meeting governance and compliance requirements, consolidating systems, and optimizing integration processes, challenge IT to find an efficient, cost-effective way to leverage data in “right time” without impacting existing applications. Until now, two common approaches have been COBOL-based hand-coded programs that extract and process bulk data and change-capture solutions that rely on application logic or file comparison techniques. Epson Stylus Pro 9600 Driver Win7. Download Free Disciplina Positiva Pdf Libro Software Reviews here.

Informatica PowerExchange™ for VSAM. Demand for timely access to critical operational data stored in VSAM files on IBM zSeries. The Informatica logo.

Informatica PowerExchange™ for VSAM offers IT organizations noninvasive software based on a service-oriented architecture featuring direct, scalable access to bulk or change-only data in real time or on a scheduled basis without requiring application programming. It removes implementation complexity, reduces overall costs, and allows IT to extend the value of existing investments in legacy applications.