• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

XML Source qualifier Transformation in Informatica

XML Source qualifier Transformation in Informatica

XML Transformation in Informatica

The XML Parser transformation lets you extract XML data from messaging systems, such as TIBCO or MQ Series, and from other sources, such as files or databases. The XML Parser transformation functionality is similar to the XML source functionality in Informatica, except it parses the XML in the pipeline.

Types of XML Transformations:

-XML Source Qualifier Transformation

-XML Parser Transformation

To get Informatica Live Training, please visit: https://tekslate.com/informatica-training/

Source Qualifier Transformation in Informatica

It is an active transformation, as well as connected transformation. Just like the normal SourceQualifier Transformation, we can use the XML Source Qualifier Transformation by dragging an XML source definition to the Mapping Designer workspace or by manually creating one. The source definition needs to be connected to the target via XML Source Qualifier Transformation. This Source qualifier defines the data elements that the Integration Service reads when it executes a session.

XML Source Qualifier has one input or output port for every column in the source. If you remove an XML source definition from a mapping, the Designer also removes the corresponding XML Source Qualifier transformation.XML Parser Transformation It’s an also active transformation, as well as Connected. We use an XML Parser transformation to extract XML inside a pipeline and then pass this to the target. The XML is extracted from the source systems such as files or databases.

The XML Parser transformation reads XML data from a single input port and writes data to one or more output ports. XML Generator Transformation Overview: It’s an also active transformation, as well as connected. We use XML Generator Transformation Overview to create XML inside a pipeline. It reads data from the source such as files and databases and generates XML in the pipeline. The XML Generator transformation accepts data from multiple ports and writes XML through a single output port.

This is type passive transformation which allows you to read the data from XML files

Every XML source definition by default associated with XML source qualifier transformation.

To read about other Informatica Transformation Tutorials, please click here

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

Creation of the source definition

From tool menu select source analyzer

From source menu click on import XML definition

Browse to the location of an XML file with the files of type. XML

Select EMP.XML file click on open, click yes

Click ok, click next

Select hierarchy relation ship, select de normalized XML views

Click on finish from repository menu click on save

Step 2:

Create a target definition with the name EMP –XML (oracle)

Step 3:

Create mapping with the name M_ XML _source

Drop source and target definitions

From XML source qualifier connect the ports to target

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

Double click the session select the mapping tab from left pane select XML.SQL_ EMP

In a properties section set the following attributes

AttributeValue
Source file directoryC:/XML
Source file nameEmp.XML
Source file typeDirect

From left pane select the target set the type normal

Click apply, click ok

[/sociallocker]

These core tutorials will help you to learn the fundamentals of Informatica. For an in-depth understanding and practical experience,  explore Informatica Training Online.

Properties of Source Qualifier

-Source Filter – Using the source filter property you can filter the number of source records. For example, you want to fetch only the employees of deptno 10, then you can enter the filter condition deptno=10 in source filter property and execute the data.

-Number for sorted ports – In source qualifier transformation, you can also sort the input records based on the ports number. So when the data is passed on to the transformations inside the mapping, it will read the port number and sort the data accordingly.

As data can be sorted based on a single or multiple ports, you have to give the number of ports which will be used in sorting. If you give value as 1, then only empno data will be sorted. If you give value as 2 then on empno and ename on both columns data will be sorted.

-Select Distinct – you can fetch only distinct records from the source using this property. When you select the select distinct option, only distinct combination of source data will be fetched by source qualifier.

For indepth understanding of Informatica click on
Summary
Review Date
Reviewed Item
XML Transformations in Informatica
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on XML Source qualifier Transformation in Informatica"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.