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
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
thanks for your reply , the Issue we have is we have about 150 XML files and all the files have diffrent XSD , should we load them one by as they have diffrent XSD
ore is there a better way to do this?
If the structure of the XML are different, then it's not possible to use single XSD to read all files.
So, you should create individual XML source definitions for all XML files and then load.
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.