Home » Transformations

XML Transformations

XML Transformations in Informatica What are the different types of XML transformations? Ans:- XML Source Qualifier Transformation, XML Parser Transformation and XML Generator Transformation. What is XML Source Qualifier transformation? Ans:- It defines the data elements that the…

Read More »

Stored Procedure transformation​ in Informatica​

​Stored ​Procedure A stored procedure is a precompiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are used to automate tasks that are too complicated…

Read More »

Performance Tuning – Aggregator Transformations

Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the performance of an Aggregator transformation: Group by simple…

Read More »

Informatica certification – Aggregator Transformation

Aggregator Transformation – My Notes  What is the use of Aggregator Transformation? Ans:- Aggregator transformation can be used to aggregate calculations (Avg, Sum, Max ..) on groups. Since its changing the number of rows its an active transformation….

Read More »

Informatica certification – Transformations

Working with Transformations – My Notes — Transformation Overview —  Which is the repository object that generates, modifies, or passes data? Ans:- A Transformation. Which transformation performs calculations on groups of data? Ans:- Aggregator Transformation. What are the…

Read More »

Informatica certification – Lookup Transformation

Lookup Transformation – My Notes What is Lookup transformation? Ans:- It can be used to look up data in a flat file, relational table, source Qualifier, view, or synonym. What are the various tasks can be performed by…

Read More »

Source Qualifier – Full Outer Join

Full Outer Join using Source Qualifier – ‘SQL Query’ Integration service support only Left & Right outer joins. We cannot perform Full outer join using ‘User Defined Join’ properties in SQ, you will get a database error. This…

Read More »

Source Qualifier – User Defined Join – Right Outer Join

How to join two tables – Source Qualifier – User Defined Join – Right Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Left Outer Join

How to join two tables – Source Qualifier – User Defined Join – Left Outer ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ…

Read More »

Source Qualifier – User Defined Join – Normal Join

How to join two tables – Source Qualifier – User Defined Join ** Source Qualifier Transformation is the most efficient way to join two tables in the same Database ** There are two options available in SQ to join multiple…

Read More »

Joiner Transformation – Normal Join

Joiner Transformation – Normal Join Let’s create a Mapping with a Joiner Transformation – Normal Join. We are going to join two tables JOB_ID1 & JOB_ID2 and create a target with the ports from two tables. Normal Join…

Read More »

Joiner Transformation Overview

Joiner Transformation Overview Use the Joiner transformation to join source data from two related heterogeneous sources residing in different locations or file systems. You can also join data from the same source. The Joiner transformation joins sources with…

Read More »

Mapping with Sorter Transformation

Mapping with Sorter Transformation # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. # All data passing through the Sorter…

Read More »

Aggregator Transformation Overview

Aggregator Transformation Overview  The Aggregator transformation performs aggregate calculations, such as average, Sum, Max & Min etc. The Aggregator is an active transformation that changes the number of rows in the pipeline. The Integration Service performs the aggregate…

Read More »

Informatica Sorter Transformation Overview

Sorter Transformation Overview # To sort data in ascending or descending order. # Can sort data from relational or flat file sources. # The Sorter transformation contains only input/output ports. # All data passing through the Sorter transformation…

Read More »