Would like some suggestion to handle a scenario. Situation consists of Access 2003 , Xml, Xsd & Xsl.
Ms Access 2003 allows to export data of a table as xml.

Lets say i have a table "mytable" in msaccess 2003 database, whose structural definition goes like:
----------------
Id integer
Name string[40]
age smallint
----------------

Exporting this table generates following XML:

-----------------------
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance">
<MyTable>
    <Id>1</Id>
    <Name>Jack</Name>
    <Age>24</Age>
</MyTable>
<MyTable>
    <Id>2</Id>
    <Name>John</Name>
    <Age>32</Age>
</MyTable>
<MyTable>
    <Id>3</Id>
    <Name>Russhel</Name>
    <Age>27</Age>
</MyTable>
</dataroot>
-----------------------

I need to generate Oracle compliant XML from this using XSL, but at the same time i want
to keep transformation dynamic, by keeping mapping information of Access table fields
to that of oracle table fields.

Map information can be:
=======================
Access Oracle
=======================
Id oSeqId
Name oFullName
Age oAge
-----------------------

Questions:

1. How do i keep this mapping information (ofcourse along with data type & other stuff per field/element)
   in a single or multiple file XSD.
2. How to Use this XSD file in a XSL to tranform the Access generated XML into Oracle compliant XML.

I have to follow the norms of not hard coding any field name in XSL, just to read the field-to-field
relation from XSD file(s) & Finding Access-fieldname in access-generated XML, reading its data value
and transforming it into another XML but with Oracle field information picked from same XSD.

----------------------------
Probable Oracle compliant XML
----------------------------
<?xml version = '1.0'?>
<ROWSET>
   <ROW num="1">
      <oSeqId>1</oSeqId>
      <oFullName>Jack</oFullName>
      <oAge>24</oAge>
   </ROW>
   <ROW num="2">
      <oSeqId>2</oSeqId>
      <oFullName>John</oFullName>
      <oAge>32</oAge>
   </ROW>
   <ROW num="3">
      <oSeqId>3</oSeqId>
      <oFullName>Russhel</oFullName>
      <oAge>27</oAge>
   </ROW>
</ROWSET>
----------------------------

Please provide some suggestion and sample code-snippet would be an added advantage in understanding, reason
being i am bit new in XML/XSL/XSD stuff.

Thanks in advance.

I wouldn't keep the mapping information in an XSD schema, I would keep it in a separate mapping file:

<mapping>
  <column access="Id" oracle="oSeqId"/>
  ...

Then you can load the mapping file into your stylesheet:

<xsl:variable name="mappings" select="document('mappings.xml')"/>

and define a key for fast access:

<xsl:key name="m" match="mapping" use="@access"/>

and then process your table as

<xsl:for-each select="*">
  <xsl:element name="key('m', name(), $mappings)">
    <xsl:value-of select="."/>
  </xsl:element>
</xsl:for-each>

This is a 2.0 solution (the call to key() with 3 arguments). It's a bit more complicated in 1.0 to access a key in another document, but you get the general idea.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference