Generating a CDATA section within the output

Here is the manual approach to generate CDATA section in the output of the Data Mapper:

1) Edit the Data Mapper activity

2) Go to Advanced Properties and add the syntax cdata-section-elements  in the <xsl:output section at the top of Mapping xsl:

<xsl:output cdata-section-elements="here enter the name of the target elements separated by space whose data needs to be encapsulated in CDATA" method="xml" version="1.0" encoding="ISO-8859-1" indent="yes"/>     

e.g. Let’s say you want to encapsulate target elements empname and empid in the CDATA section then the modified xsl syntax will be  :

 <xsl:output cdata-section-elements="empname empid" method="xml" version="1.0" encoding="ISO-8859-1" indent="yes"/>