top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to write low value and high value in power exchange target in informatica?

+1 vote

In my mapping I have one power exchange target, in which header and trailor record type are having low and high value. Without changing the datamap can we write low and high value through informatica?

posted Jul 22, 2014 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
What you had tried???
I have used 00 string(3) for low value and 255 string(3) in expression transformation. In the target I have modified the corresponding field as NUM8U but it is throwing truncation error for the high value.

1 Answer

0 votes

Use custom properties on session level.

Please comment if not solved.

answer Jul 23, 2014 by anonymous
I have modified custom properties but still getting truncation error.
Severity    Timestamp    Node    Thread    Message Code    Message
ERROR    7/24/2014 12:12:32 PM    node01_InfaE2    WRITER_2_*_1    WRT_8164    Error loading into target [qkumstrn_QKUMSTR_TRL] : Insert operation failed
[Informatica][SCLI PWX Driver] PWX-00267 DBAPI Error. DB_INSERT failed for file mnm.qkumstrn_QKUMSTR_TRL.
[Informatica][SCLI PWX Driver] PWX-00141 DBAPI Error. 1 data conversion errors during write of block that commenced at row 1.
[Informatica][SCLI PWX Driver] PWX-00143 DBAPI Error. Conversion error during write. RC=1. DB="mnm.qkumstrn_QKUMSTR_TRL". Column="QKUMSTR_REC_TYPE". Msg="PWX-00312 CNV Truncation error.".

What are the other changes required?
Similar Questions
+1 vote

I am using power exchange to read/write mainframe files through listeners, is it possible to handle low values/high values present in mainframe files through informatica ?

Thanks in advance.

0 votes

Currently datasets are getting generated in MF if there are 1 or more than 1 records coming from source. If there are no records from source, then empty data set is not created in MF.

As a solution, we tried to give pre-sql in session specifying all basic properties. But still our session failed with the below error:

Message Code: PWXPC_12015 Message: [ERROR] Error message: 
[[Informatica][SCLI PWX Driver] PWX-00265 DBAPI Error. DB_EXECSQL failed for file . 
[Informatica][SCLI PWX Driver] PWX-01275 DBNTC ExecSQL failed for file , rcs 260/265/0.]