Informatica 7.1: XSD and XML file for SCOTT Emp table.My first mapping in xml

1/
As a xml editor I used Stylus .
By this you can get data into xml file from EMP table.
File-->New-->DB to XML Datasource.
Connect to the databse.Select EMP table and get data as xml.

The stylus will run this following query
SELECT
XMLELEMENT(name "row",
XMLELEMENT(name "EMPNO",t.EMPNO),
XMLELEMENT(name "ENAME",t.ENAME),
XMLELEMENT(name "JOB",t.JOB),
XMLELEMENT(name "MGR",t.MGR),
XMLELEMENT(name "HIREDATE",t.HIREDATE),
XMLELEMENT(name "SAL",t.SAL),
XMLELEMENT(name "COMM",t.COMM),
XMLELEMENT(name "DEPTNO",t.DEPTNO)
)
FROM EMP t

to get data in XML.

The file is DOWNLOAD EMP XML FILE

2/
Create a schema for that emp.xml as XML-->Create Schema from XML content.
You can create a XSD or DTD ( internal/external)
DOWNLOAD EMP EXTERNAL DTD
DOWNLOAD EMP XML WITH INTERNAL DTD
DOWNLOAD EMP XSD

3/
Use that EMP XSD to create XML view.Tools-->Source Analyzer-->Import XML Defination.

4/
Develop necessary transformation and flow data.

POINTS TO PONDER:
=================

0>> Check in Workflow Manager for the path for source XML.
0>> Apply transformation if there is a need for data conversion.




---: I am not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m.a.hasim@inbox.com