Search code examples
xmlinformaticainformatica-powercenter

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;


Solution

  • I came across this in a KB. Please check if this is applicable in your case.

    When the attribute of an element in the mapping is projected and not the element itself, then when the null is passed to the attribute, the attribute will be suppressed. However, the empty element tag will still be created in the target XML filebecause, the Null Content Representation=No Tag will be in effect only when the element is projected.

    Solution

    To suppress the empty element tags, project these elements in the mapping and pass the NULL value