Informatica Interview Questions and Answers
Freshers / Beginner level questions & answers
Ques 1. What is Informatica PowerCenter?
Informatica PowerCenter is an ETL (Extract, Transform, Load) tool used for data integration and warehousing.
Ques 2. What is a Session in Informatica?
A session in Informatica is a task that represents the execution of a workflow. It is the smallest unit of work in a workflow.
Ques 3. What is a Repository in Informatica?
A repository in Informatica is a relational database that stores metadata and configuration information about the various objects managed by Informatica.
Ques 4. What is a Workflow in Informatica?
A workflow in Informatica is a set of instructions for the integration service to execute the tasks defined in a mapping.
Ques 5. What is the purpose of the Aggregator transformation?
The Aggregator transformation in Informatica is used to perform aggregate calculations such as sum, average, minimum, maximum, etc., on groups of data.
Ques 6. What is the purpose of a Sequence Generator transformation?
The Sequence Generator transformation in Informatica is used to generate unique sequence numbers for rows in a data set.
Ques 7. What are the different types of transformations in Informatica?
Informatica supports various transformations, including Aggregator, Filter, Router, Lookup, Expression, Joiner, and many others.
Ques 8. What is the purpose of a Source Qualifier transformation?
The Source Qualifier transformation in Informatica is used to specify properties for reading data from a relational or flat file source.
Ques 9. Explain the concept of a Filter transformation.
A Filter transformation in Informatica is used to filter rows based on specified conditions, allowing only the required rows to pass through.
Ques 10. Explain the concept of a Parameter File in Informatica.
A Parameter File in Informatica is a text file that contains parameter values used to replace placeholders in session and workflow properties at runtime.
Ques 11. What is the purpose of a Router transformation in Informatica?
A Router transformation in Informatica is used to filter data rows to different output groups based on specified conditions.
Ques 12. How can you create a reusable session in Informatica?
A reusable session in Informatica can be created by defining the session as reusable in the session properties and saving it to the repository for use in multiple workflows.
Ques 13. How can you handle null values in Informatica?
Null values in Informatica can be handled using functions like ISNULL and COALESCE, or through the use of NULL indicator ports in transformations.
Ques 14. Explain the concept of a Joiner transformation.
A Joiner transformation in Informatica is used to combine rows from two heterogeneous sources based on a common column, similar to an SQL join operation.
Most helpful rated by users:
Related interview subjects
| Oracle CXUnity interview questions and answers - Total 29 questions |
| Web Services interview questions and answers - Total 10 questions |
| Salesforce Lightning interview questions and answers - Total 30 questions |
| Power BI interview questions and answers - Total 24 questions |
| IBM Integration Bus interview questions and answers - Total 30 questions |
| OIC interview questions and answers - Total 30 questions |
| Web API interview questions and answers - Total 31 questions |
| Dell Boomi interview questions and answers - Total 30 questions |
| Talend interview questions and answers - Total 34 questions |
| Salesforce interview questions and answers - Total 57 questions |
| IBM DataStage interview questions and answers - Total 20 questions |
| TIBCO interview questions and answers - Total 30 questions |
| Informatica interview questions and answers - Total 48 questions |