Saturday 12 December 2015

INFORMATICA XML SOURCE TRANSFORMATION

For XML files processing XSD is required.
Please collect XML file and XSD files from Institution.

1. Import XML definition in source analyzer like below
      Source Analyser->Sources->Import XML Definistion->Specify XSD file->OK
2.  Create a mapping with the below flow.
   Drag and Drop Party_XML from sources list, connect to flat file to load
3. Create session and specify the below

    For source 
                      Specify XML file location (not XSD)
                      Directory: c:\
                      Filepath: Data\party_xml.xml
   For Destination
                   Directory: c:\
                   Filepath : Data\XML_Opt.txt
            
 

3 comments:

  1. This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.
    Informatica Training in Chennai

    ReplyDelete
  2. This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
    informatic Training in hyderabad
    informatic online Training in hyderabad

    ReplyDelete