This content has been marked as final. Show 3 replies
So finally it is tricky :-)
I needed to to populate the data to the target with XML driver system function IFNULL(NameOfColumn,'') execute it on the stage in ODI inteface. After this one can play with driver switch from the documentation:
no_closing_tags or nct
boolean (true | false)
If this property is set to true, the driver generates the empty tags without their closing tags (for example <element/>). If set to false the driver generates an empty element as <element></element>. This property is true by default if the v1_compatibility property is used.
But still without using IFNULL or different way of populating the data on the stage it won't work.