XML SQ(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

To get Informatica Live Training, please visit: Click Here....

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) a XML source definition to the Mapping D(Designer) workspace or by physically making one. The definition of 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 a 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 a XML Parser change to separate pipeline inside a 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 additionally dynamic change, and associated. We utilize XML Generator Transformation Overview to make pipeline inside a 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 NO>7360</EMPNO>





<EMP NO>7499</EMPNO>






With the source definition Formation

From instrument menu select source analyzer

From source menu tap on import XML definition

Peruse to the area of a 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 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 left sheet select XML.SQL_ EMP

In a properties segment set the accompanying characteristics

Source document indexC:/XML
Source document nameEmp.XML
Source document write Coordinate

From left pane select the target set the type normal.

For indepth understanding of Informatica click on