Cognizant Informatica Developer Interview Questions and Answers

PowerCenter is an on-premise data integration tool, while IICS is a cloud-based integration platform.

• PowerCenter is on-premise, IICS is cloud-based

• PowerCenter is a traditional ETL tool, IICS is a modern integration platform

• PowerCenter requires infrastructure setup, IICS is managed by Informatica

• PowerCenter is more suitable for large enterprises with on-premise data, IICS is better for cloud-based integrations

Types of caches include memory cache, disk cache, and browser cache.

• Memory cache stores data in memory for quick access.

• Disk cache stores data on the hard drive for faster retrieval.

• Browser cache stores web page elements to reduce loading times.

• Other types include CPU cache, page cache, and object cache.

Char is fixed length string data type, while varchar is variable length string data type.

• Char stores fixed length strings, while varchar stores variable length strings.

• Char pads with spaces to reach fixed length, while varchar does not pad.

• Char is faster for fixed length data, while varchar is more flexible for variable length data.

To connect a session using Unix, you can use the pmcmd command with appropriate arguments.

• Use the pmcmd command followed by the connect option to connect to the Informatica session.

• Provide the necessary connection details such as domain, repository, username, and password.

• You can also specify the session name and folder path if needed.

• Example: pmcmd connect -sv MyInformaticaServer -d MyDomain -u MyUsername -p MyPasswor

Active transformations change the number of rows that pass through them, while passive transformations do not change the number of rows.

• Active transformations can filter, update, or modify the number of rows in a data stream (e.g. Filter, Router, Update Strategy).

• Passive transformations do not change the number of rows in a data stream, they only allow data to pass through unchanged (e.g. Expression, Lookup, Sequence G

Different types of lookup caches include persistent cache, dynamic cache, and shared cache.

• Persistent cache stores lookup data in a flat file or database table for reuse across sessions.

• Dynamic cache dynamically loads lookup data into memory as needed during a session.

• Shared cache allows multiple sessions to share the same cache for improved performance.

Filter is used to pass or reject data based on conditions, while router is used to route data to different targets based on conditions.

• Filter is used to include or exclude data based on specified conditions.

• Router is used to direct data to different targets based on specified conditions.

• Filter is typically used to remove unwanted data, while router is used to split data flow.

• Example: Using filter to exclude records wit...read more

To find the 2nd or 3rd highest salary in SQL, use the 'ORDER BY' and 'LIMIT' clauses.

• Use the 'ORDER BY' clause to sort the salaries in descending order.

• Use the 'LIMIT' clause to specify the number of rows to return.

• For 2nd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

• For 3rd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2,1

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 infrastructur...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...read more