top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to generate empty data set in mainframe through Informatica Power Exchange?

0 votes
641 views

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.]
posted Jun 3, 2014 by anonymous

Looking for an answer?  Promote on:
Facebook Share Button Twitter Share Button LinkedIn Share Button

Similar Questions
+1 vote
How to write low value and high value in power exchange target in informatica?

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?

+1 vote
Import data from db2 using informatica power Center without powerexchange

How to Import data from db2 table using informatica power Center without powerexchange.

+2 votes
How to delete the empty TAGS while publishing XML in Informatica Target

I am publishing a XML as Informatica Target and I am getting empty tags in the published file. I have already treid the below mentioned settings but still empty tags are coming.
XML null content representation-> No Tag
XML empty string content representation->No Tag
XML null attribute representation->No Attribute
XML empty string attribute representation->No Attribute
and below mentioned Custom Properties
WriteNullXMLFile=No;SuppressNilContentMethod=ByTree;

...