XML sources

HI all,

This posts breifly tells about handling xml sources in informatica .

Well basic types are .xml or .dtd or .xsd formats which informatica supports and in general to tell the difference between .xml and .dtd is the .dtd contains only the structure of the file where as xml contains structure as well as the data in it.

when you tryto import the xml sources in to the informatica source analayser you will basically have options where you go for entity or hierarchy or custom , the option to be chossed is better off if we decide it with the xml files and when you try to import the file to the source analyser
you see it element has been divided into different groups (segments ) and as the xml source qualifier is an active transformation we cannot take the output from two different segment to the same target table,Instead if we need do so we can take a joiner and join on the keys generated from the xml files.

And in case of indirect load the file list always excepted a space carriage at the end of the file.