3 Replies Latest reply on Jul 1, 2020 8:34 PM by Smitha HC

    In Informatica powercenter how to load multiple column data into the single Attribute list of XML

    Thenmozhi Durairaj New Member

      Hi,

       

      my Target XML look like,

       

      <Product UserTypeID="sample1" ID="001">

           <Values>

                <Value AttributeID="Empno">101</Value>

                <Value AttributeID="Name">Ram</Value>

                <Value AttributeID="Age">34</Value>

           </Values>

      </Product>

       

      while importing this XML target into informatica.I am only getting Product,values,value and single AttributeID.

       

      My requirement is to load EMPNO,Name and Age to target.With this single AttributeId how I am load the data of these three ports?

      Is there any other way to get this AttributeID port three time or based on the dataValue of that attribute?

       

      I tried all the options in infa PC while importing the XML definition but nothing will help.Please suggest Any way to attain this?