What is transformation in Informatica?

What is transformation in Informatica?

List of Transformations in Informatica

• Source Qualifier Transformation.
• Aggregator Transformation.
• Router Transformation.
• Joiner transformation.
• Rank Transformation.
• Sequence Generator Transformation.
• Transaction Control Transformation.
• Lookup and Re-usable transformation.

What is lookup transformation in Informatica?

The Lookup transformation returns the result of the lookup to the target or another transformation. You can configure the Lookup transformation to return a single row or multiple rows. When you configure the Lookup transformation to return a single row, the Lookup transformation is a passive transformation.

How can we use stored procedure in Informatica?

Stored Procedure Transformation in Informatica

1. Check the status of a target database before loading data into it.
2. Determine if enough space exists in a database.
3. Perform a specialized calculation.
4. Dropping and recreating indexes.

How does the SQL transformation work in Informatica?

We can insert, update, delete and retrieve rows from the database at run time using the SQL transformation. The SQL transformation processes external SQL scripts or SQL queries created in the SQL editor. You can also pass the database connection information to the SQL transformation as an input data at run time.

What do you need to know about SQL transformation?

Database Type: The type of database that the SQL transformation connects to. Connection type: You can pass database connection information or you can use a connection object. We will see how to create an SQL transformation in script mode, query mode and passing the dynamic database connection with examples.

What are the advantages of the source qualifier transformation?

The advantages and limitations are explained below: The source qualifier transformation is used to perform many complications join or merge, filter conditions in a simple way that can be pushed directly to the database without involving the Informatica to compute the queries.

Where is the SQL employee variable in Informatica?

So, click on the SQL_Employee present in the Transformations folder. Within the Connections, click on the Arrow button beside the Relational type, and use the Connection variable $Source. It is because we used the Select Statement to select records from Informatica Source.