Why -- In earlier post we saw how can we use XML Source in a mapping, when the input file is a XML format. However, that is not always a case. Most of the times, instead of physical file, designer store the xml file text into database column. In such cases, we can not have XML as a Source, but it has to be a relational source.
If that's the case, then how can you read / parse the xml text? Informatica has provided XML Parser for it, it works same as your XML Source, however the difference between these 2 is, for XML Source we give file path as an input and for later one text port is an input
How -- How is works? its simple... please have a look at below mapping --
As stated earlier, our source is Oracle and XML Value will come as an Text, which we will give as an input to XML Parser.
XML Parser will do the same work as XML Source which we had seen in earlier post. You can refer below link to learn more about relationships between XML Entities.
http://gyaankatta.blogspot.in/2014/04/59-explain-any-scenario-of-xml-as-source.html
As shown in above image, XMLText column from source will act as an input to XML Parser's DataInput port. and remaining part will be same as earlier post which we have seen.
If that's the case, then how can you read / parse the xml text? Informatica has provided XML Parser for it, it works same as your XML Source, however the difference between these 2 is, for XML Source we give file path as an input and for later one text port is an input
How -- How is works? its simple... please have a look at below mapping --
XML Parser will do the same work as XML Source which we had seen in earlier post. You can refer below link to learn more about relationships between XML Entities.
http://gyaankatta.blogspot.in/2014/04/59-explain-any-scenario-of-xml-as-source.html
No comments:
Post a Comment