Furious Computer Solutions 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

Cubes are multidimensional structures used in OLAP (Online Analytical Processing) to analyze data from multiple perspectives.

• Cubes store aggregated data for faster analysis

• They allow users to drill down into data to analyze at different levels of granularity

• OLAP cubes are used in business intelligence for complex data analysis

• Examples include sales cubes, finance cubes, and customer analysis cubes

ETL pipeline stands for Extract, Transform, Load pipeline used to extract data from various sources, transform it, and load it into a data warehouse.

• ETL pipeline involves extracting data from multiple sources such as databases, files, APIs, etc.

• The extracted data is then transformed by applying various operations like cleaning, filtering, aggregating, etc.

• Finally, the transformed data is loaded into a data warehouse or...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

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