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.
XML SQ(Source Qualifier) Transformation Example
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.
Make an objective definition with the name EMP – XML (prophet)
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 index||C:/XML|
|Source document name||Emp.XML|
|Source document write||Coordinate|
From left pane select the target set the type normal.