top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Including empty tag in xml while using xml as target in Informatica

+2 votes
929 views

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.

posted Oct 8, 2014 by Sunil

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

1 Answer

0 votes

I session at target level there is a property named : XML null content representation change it to : Tag with Empty Content and it will generate an empty tag if there is null value from source.

answer Oct 13, 2014 by Shweta Singh
Similar Questions
+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;

0 votes
Informatica - Using single target multiple times in single mapping

Can you use a target table in multiple areas of a single mapping.

I have routers around the table, where I know some rows are ready, and currently they are all going to a final Union transformation.

I am wondering if it is possible to direct these from the router, directly into the multiple instance of a single target table.

If so, how does Informatica do the inserts?

Will it each time queue the outputs into the same target, or try and insert them concurrently when and as it stumbles upon them?

+1 vote
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

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 ?

...