Informatica Developer Interview Questions and Answers for Freshers

IICS is a cloud-based data integration platform while Power Centre is an on-premise data integration tool.

• IICS is a newer platform compared to Power Centre

• IICS offers more advanced features such as AI and machine learning capabilities

• Power Centre is more suitable for large-scale data integration projects

• IICS is more flexible and scalable due to its cloud-based nature

• Power Centre requires more hardware and infrastructure to run

• Both platforms offer similar functionalities such ...read more

Secure Agent is a lightweight program that runs on-premises or in the cloud to securely connect to data sources.

• Secure Agent is used in Informatica Cloud to securely connect to on-premises data sources

• It is a lightweight program that can be installed on-premises or in the cloud

• Secure Agent uses SSL/TLS encryption to secure data in transit

• It can be configured to run on a schedule or triggered by an event

• Examples of data sources that can be accessed using Secure Agent include d...read more

Types of transformations include expression, filter, aggregator, join, lookup, and more.

• Expression transformation: Perform calculations or manipulate data

• Filter transformation: Filter rows based on specified conditions

• Aggregator transformation: Perform aggregate calculations like sum, average, etc.

• Join transformation: Combine data from multiple sources based on a common key

• Lookup transformation: Retrieve data from a relational table based on a lookup condition