top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+2 votes
302 views

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;

posted Oct 15, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

In session properties go to config object tab. In custom properties field write this

WriteNullXMLFile = No;SuppressNilContentMethod=ByTree 
answer Oct 17, 2014 by Shweta Singh
Similar Questions
+2 votes

I am using xml as target in my mapping in Informatica.Suppose there is no value for a port ,but I want to generate it as empty element in the xml file generated as . I tried with nillable="true",but in the o/p file it is coming as . But I want it to be :

I also tried with union operation . It is giving the error: Value not matching any of the member types in the union. Please suggest.

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.]
+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...