top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

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

+2 votes
601 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

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

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

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
...