Skip navigation
Contact Us
2145 Views 6 Replies Latest reply: Feb 13, 2013 10:01 PM by Prashant Kumar RSS
Sathish Shankar Novice 20 posts since
Jul 6, 2012
Currently Being Moderated

Feb 11, 2013 10:00 AM

Load XML files to Oracle

Hi Gurus,

 

I am new to working with XML files using informatica

we have some xml files , how to load them to oracle with informatica i know we have xml source qualifier for this but my question is do we need a XSD for loading the xml files or does informatica treat xml like flat files ie CSV ie how to specify the delimeters or postion where to look for the data in the xml

 

thanks,

sathish

  • Info 2005 Novice 35 posts since
    May 16, 2012
    Currently Being Moderated
    Feb 11, 2013 11:30 AM (in response to Sathish Shankar)
    Load XML files to Oracle

    XML file(Data input)--XML Parser -connect to Tgt

  • Prashant Kumar Apprentice 248 posts since
    Sep 18, 2007
    Currently Being Moderated
    Feb 11, 2013 8:15 PM (in response to Sathish Shankar)
    Load XML files to Oracle

    Hi,

     

    First you need to create XML Source definition. to do this, either you should have XSD or you can create from XML data file itself. But if you create XML source definition, you need to verify that, all data types are correct in it.

     

    Please update us if you need more information

     

    Thank you

    Prashant

  • Vinayaka KR Newbie 16 posts since
    Jul 15, 2011
    Currently Being Moderated
    Feb 13, 2013 9:48 PM (in response to Sathish Shankar)
    Load XML files to Oracle

    As per my understanding xsd is not mandatory. we have created some mappings without out using xsd file.

    • Prashant Kumar Apprentice 248 posts since
      Sep 18, 2007
      Currently Being Moderated
      Feb 13, 2013 10:01 PM (in response to Vinayaka KR)
      Load XML files to Oracle

      Hi Vinayaka,

       

      Yeah, XSD is not mandatory. But as i explained in earlier post, it is possible to create XML source definition using XML file. But this is not the correct way of creating XML definition. Thsi approach is like creating a Database Table by looking at the data. Unless you have Table Definition, you will never know, what is the correct datatype for the given field, A number can be loaded into a  field with datatype Varchar and integer.

       

      For Example : The XML definition created by using XML file, will have data types as per the data available in XML file. But not as per the XSD.

       

       

      Thank you

      Prashant

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points