0 Replies Latest reply on Sep 4, 2012 8:12 PM by sridevi.kota@accenture.com

    How to generate PK and FK in the midstream XML generator Transformation

    New Member

      Hi,

      I have a requirement where I would need to generate an XML file. Order is the root element. Details,product are multiple-occurring elements of minoccurs 1 to maxoccurs 20.

       

      Order has attributes Description, Details has First name, Last name. Product has Id and Description. For each order , there would be multiple occurrences of firstname, last name and ID and Description.

       

      In the XML Generator Transformation I have Primary keys and Foreign Keys genearted, for example Order has a PK_Order , Details has PK_Details and FK_Order, Product has PK_Product and FK_Order. Can some one help me with the logic that I would need to use to generate the PK and FK for the root element and it associated child elements.

       

      Appreciate your help.

       

      Thanks,

      DS