I am working on Informatica Power Center and my requirement is to create an XML file. There are a few conditions to create the file. They are: If any date columns, like 'BIRTH_DT', have NULL or only Spaces, then BIRTH_DT should not be seen in the target file.
Output at the moment: Current Output
Desired Output, since BIRTH_DT is blank: Desired Output
Is there any way to accomplish this?