This is extension to link http://gogates.blogspot.com/2011/09/xml-source.html
We will first see the difference between the options we get while importing the XML definition.
Our XML source is like below taken from link -- http://www.w3schools.com/xml/xml_attributes.asp
<note>
<date>
<day>10</day>
<month>01</month>
<year>2008</year>
</date>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>
We used 2 options as seen in the screenshot
This is a first option as
This is a second option as
Basically it changes the xml source node column name. Please find the below difference of both cases
If you see, there is a difference in primary key name and main node name. Second has same name as of xml definition whereas first has name generated of its own.
We will first see the difference between the options we get while importing the XML definition.
Our XML source is like below taken from link -- http://www.w3schools.com/xml/xml_attributes.asp
<note>
<date>
<day>10</day>
<month>01</month>
<year>2008</year>
</date>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>
We used 2 options as seen in the screenshot
This is a first option as
Basically it changes the xml source node column name. Please find the below difference of both cases
No comments:
Post a Comment