Active Transformations are those who modifies the data rows and the number of input rows passed to them. For example, if a transformation receives ten number of rows as input, and it returns fifteen number of rows as an output then it is an active transformation.

What is difference between active and passive transformation?

An active transformation is a transformation which actually changes the physical position (alibi, elsewhere) of a point, or rigid body, which can be defined in the absence of a coordinate system; whereas a passive transformation is merely a change in the coordinate system in which the object is described (alias, other …

What is active and passive Lookup transformation in Informatica?

When you configure the Lookup transformation to return a single row, the Lookup transformation is a passive transformation. When you configure the Lookup transformation to return multiple rows, the Lookup transformation is an active transformation.

Why sorter is active transformation in Informatica?

Its called active transformation because when we want the distinct rows to be sorted and once the sort happens we have rows with the duplicate data eliminated. This happens by setting the distinct output rows property to true. Hence Sort Transformation is called active Transformation.

Is router active or passive transformation?

active transformation

The Router transformation is an active transformation that you can use to apply a condition to incoming data. passes the row multiple times. You can either drop rows that do not meet any of the conditions or route those rows to a default output group.

Can we connect 2 active transformations in Informatica?

You cannot connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group. You might not be able to concatenate the rows.

Is stored procedure an active transformation?

Stored Procedure Transformation in Informatica is a passive transformation and can be used in both connected and unconnected mode. The stored procedures are stored and run within the database and it also contains a pre-compiled collection of PL-SQL statements.

Is Joiner an active transformation?

The Joiner transformation is an Active and Connected Informatica transformation used to join two heterogeneous sources. The joiner transformation joins sources based on a specified condition that matches one or more pairs of columns between the two sources.

Is Union an active transformation?

The Union transformation is an active transformation that you use to merge data from multiple pipelines into a single pipeline. For data integration patterns, it is common to combine two or more data sources into a single stream that includes the union of all rows.

Is look up is active or passive?

passive transformation

Lookup is a passive transformation because it will return a value if a match is found and null or default if a match is not found. It does not changes the number of records processed and thus is a passive transformation.

What is a mapplet in Informatica?

A mapplet is a reusable object containing a set of transformations that you can use in multiple mappings. Use a mapplet in a mapping. Or, validate the mapplet as a rule. Transformations in a mapplet can be reusable or non-reusable. If you add a Sequence Generator transformation to a mapplet, it must be reusable.

Which of the following are active transformations?

The following is the list of active transformation in Informatica used for processing the data –

  • Source quilter transformation in Informatica.
  • Filter transformation in Informatica.
  • Ruler transformation in Informatica.
  • Rank Transformation in Informatica.
  • Sorter Transformation in Informatica.

What is the difference between filter and Router transformation in Informatica?

Router transformation provides mutually inclusive groups to have the same records, whereas Filter transformation used to restrict the incoming record. – Router transformation doesn’t block the incoming record, whereas Filter transformation blocks or restricts the incoming record on the condition given.

What is difference between Joiner and Lookup transformation in Informatica?

Joiner is used for joining two homogeneous or heterogeneous sources residing at different locations. Lookup is used to look-up the data. Joiner is an Active Transformation. Lookup transformation is a Passive transformation.

What is the difference between stop and abort?

STOP option allows the writing of the data and committing the data to the targets, whereas ABORT shows no commitment as such. – STOP option doesn’t kill any process and it just stops the resource sharing between the processes, whereas ABORT stops the process and the session gets terminated.

What is the difference between source qualifier and filter transformation?

By using Source Qualifier we can filter out records from only relational sources. But by using Filter Transformation we can filter out records from any sources.In Filter Transformation we can use any expression to prepare filter condition which evaluates to TRUE or FALSE. The same cannot be done using Source Qualifier.

What is difference between SQL override and lookup override in Informatica?

The role of SQL Override is to limit the number of incoming rows entering the mapping pipeline, whereas Lookup Override is used to limit the number of lookup rows to avoid the whole table scan by saving the lookup time and the cache it uses. Lookup Override provides only Non-Equi joins. SQL Override doesn’t do that.

Can we join two flat files using source qualifier?

No, source qualifier transformation cannot be used for joining Flat file Source. The source qualifier transformation can be used to join sources from the same database(Homogeneous sources).

What is Joiner transformation?

The Joiner transformation joins data based on the join conditions and the join type. A join condition matches fields between the two sources. You can create multiple join conditions. A join type defines the set of data that is included in the results.

Can we generate surrogate key in Informatica?

Surrogate keys are used to store history and they are generated using sequence generator . Also you can version the records using sequence no using look up and expression transformation.

What is incremental aggregation in Informatica?

Incremental Aggregation is the process of capturing the changes in the source and calculating the aggregations in a session. This process makes the integration service to update the target incrementally and avoids the process of calculating the aggregations on the entire source.

What is full outer join in Informatica?

The Full Outer Join in Informatica is another option available in Joiner Transformation which is used to return all the existing records from Master table and Detail table.

What is tracing level in Informatica?

Tracing levels in Informatica define the amount of data you wish to write in the session log when you execute the workflow. The tracing level is a very important aspect of Informatica, as it helps in analyzing errors.

How many pipelines can a joiner transformation join?

The joiner transformation is used to join two heterogeneous sources. The joiner transformation joins sources on the basis of a condition that matches one or more pairs of columns between the two sources. The two input pipelines include a master and a detail pipeline.

Can we join two flat files using Joiner transformation?

Heterogeneous Join : Heterogeneous Join need to be created using Joiner Transformation. Example : An Oracle table and a DB2 table, A flat file and database table, Two flat files. If you can perform a join on the source database, then you can configure it in the Source Qualifier.

What is homogeneous and heterogeneous in Informatica?

For example if a mapping is using only Oracle sources or Flat files or DB2 or XML or any other then they are called Homogeneous sources. Example of Heterogeneous is if a mapping is using Oracle source table, Flat file, DB2 source and XML Source then they are called as Heterogeneous sources.