Accenture 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

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

Database is a collection of related data while data warehouse is a large collection of data used for business analysis.

• Database is used for transactional processing while data warehouse is used for analytical processing.

• Database is designed for day-to-day operations while data warehouse is designed for decision-making purposes.

• Database is usually smaller in size while data warehouse is much larger in size.

• Database is n...read more

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

SQL joins are used to combine rows from two or more tables based on a related column between them.

• Types of SQL joins include: INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN)

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matc