Question:  Design a mapping with expression to load the first 5 rows from a flat file into a target in Informatica Powercenter?

Step1. Assign row number to each record.

Step2. Generate row number using expression or by using sequence generator.

Step3. Now pass the output of filter transformation to target with filter condition as o_rowcount<=5.

Question: What are the differences between connected lookup and unconnected lookup?

Question: What is the different tool available for ETL Process?

Enterprise Software ETL

Informatica PowerCenter

IBM Datastage

Abinitio

Oracle Data Integrator

Microsoft SQL Server Integration Services (SSIS)

SAP Data Services

SAS Data Manager

Open Source ETL

Talend Open Studio.

Pentaho Data Integration (PDI)

Hadoop.

Custom ETL

AWS EMR

AWS Glue.

AWS Data Pipeline.

Azure Data Factory

Google Cloud Dataflow.

Segment.

Stitch.

Question: What are the Informatica Powercenter components?

PowerCenter Service

PowerCenter Domain 

Integration Service 

PowerCenter Administration Console 

Web Service Hub 

PowerCenter Repository 

PowerCenter Clients 

Repository Service 

Question: What do you mean by data driven concept in Informatica PowerCentre?

Data-driven properties determine how Informatica Server processes data when a mapping uses an update strategy transformation. If you use the update strategy transformation, whether you want DD_UPDATE (constant to update a data set), DD_INSERT (constant to insert a data set), or DD_DELETE (constant to delete a data set). Must be specified. A mapping can contain multiple update strategy transformations. Therefore, to successfully run a session, you must specify data-driven properties in the session properties for that mapping.

Three types of Data Driven concept generally used.

DD_INSERT: For inserting record in target table.

DD_UPDATE: For updating record in target table.

DD_DELETE: For deleting record in target table.

Question: How can the performance of Informatica Aggregator Transformation is improved?

Consider the following factors to improve the performance of Aggregator Transformation in Informatica Power Centre.

Using sorted input reduces the amount of cached data and this improves session performance.

Filter unnecessary data before aggregation to reduce the scope of unnecessary aggregation.

To reduce the size of the data cache, connect only the inputs/outputs required for subsequent transformations.

Question: What are different lookup caches in Informatica Powercenter?

Following types of cache are used in Informatica PC.

Static Cache

Persistent Cache

Shared Cache

Dynamic Cache

Reached

Click here, for more Informatica Powercenter interview Question and Answer