XML Source qualifier Transformation in Informatica

XML Transformation in Informatica

The XML Source qualifier Transformation in Informatica, XML Parser change gives you a chance to remove XML information from informing frameworks, for example, TIBCO or MQ Series, and from different sources, for example, documents or databases. The XML Parser change usefulness is like the XML source usefulness in Informatica, with the exception of it parses the XML in the pipeline.

Sorts of XML Transformations:

- XML SQ(Source Qualifier) Transformation

- XML P(Parser) Transformation

Source QT(Qualifier Transformation) in Informatica

It is a dynamic change, and in addition, associated change. Much the same as the ordinary SourceQualifier Transformation, we can utilize by dragging the XML SQ(Source Qualifier) an XML source definition to the Mapping D(Designer) workspace or by physically making one. The definition of the source should be associated with the objective by means of XML SQ(Source Qualifier). This Source qualifier characterizes the information components that the Integration Service peruses when it executes a session.

XML SQ(Source Qualifier) has one info or yield port for each segment of the source. On the off chance that you expel mapping from an XML source definition, the Designer likewise evacuates the comparing XML SQ(Source Qualifier) transformation.XML P(Parser) Transformation It's an additionally dynamic change, and also Connected. We utilize an XML Parser change to separate pipelines inside an XML and after that pass this to the objective. The XML is removed from the source frameworks, for example, documents or databases.

The XML Parser change peruses XML information from a solitary info port and composes information to at least one yield ports. XML Generator Transformation Overview: It's an additional dynamic change, and associated. We utilize XML Generator Transformation Overview to make a pipeline inside an XML. It peruses information from the source, for example, documents and databases, and creates XML in the pipeline. The XML Generator change acknowledges information from various ports and composes XML through a solitary yield port.

This is type latent change which enables you to peruse the information from XML documents

Each XML source definition of course connected with XML source qualifier change.

To peruse about other Informatica Transformation Tutorials, please click here

XML SQ(Source Qualifier) Transformation Example

[sociallocker id=14723]

EMP.XML:

<EMP>

<EMP-DETAILS>

<EMP NO>7360</EMPNO>

<ENAME>SMITH</ENAME>

<SAL>4500</SAL>

<DEPTNO>10</DEPTNO>

</EMP_DETAIL>

<EMP NO>7499</EMPNO>

<ENAME>ALLEN</ENAME>

<SAL>6000</SAL>

<DEPTNO>20</DEPTNO>

</EMP_DETAIL>

</EMP>

With the source definition Formation

From the instrument, menu select source analyzer

From the source, menu tap on import XML definition

Peruse the area of an XML document with the records of sort. XML

Select EMP.XML record tap on open, click yes

Snap alright, click straightaway

Select order connection transport, select de standardized XML sees

Tap on complete from store menu tap on spare.

Stage 2:

Make an objective definition with the name EMP – XML (prophet)

Stage 3:

Make mapping with the name M_ XML _source

Drop source and target definitions

From the XML source qualifier interface the ports to target

Make a session with the name S _ M _XML _ source

Double-tap the session select the mapping tab from the left sheet select XML.SQL_ EMP

In a properties segment set the accompanying characteristics

From the left pane select, the target sets the type normal.