Table of Contents
What is Informatica interview questions and answers?
Informatica Basic Interview Questions
- What do you mean by Enterprise data warehouse?
- What is ETL (Extract, transform, Load) and write some ETL tools.
- What is Informatica PowerCenter?
- Name different types of transformation that are important?
- Write the difference between connected lookup and unconnected lookup.
How can I prepare for Informatica?
10 Important Informatica Questions you should prepare for before your interview
- What do you understand by Informatica?
- What is a domain?
- Tell us the number of repositories that you can create in Informatica.
- What do you understand by sessions?
- Tell us about Aggregator Transformation.
- What is role playing dimension?
What is Transformation developer in Informatica?
The transformations created in the Transformation Developer are reusable, that is, you can use them across multiple Mappings or Mapplets. With this basic understanding, we are all set to jump into the most important aspect of Informatica PowerCenter tool–the transformations.
What is Informatica in simple terms?
Informatica is a Software development company, which offers data integration products. It offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.
What is Informatica experience?
Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organizations including telecommunication, health care, financial and insurance services.
How many rounds of interview are there in Informatica?
Informatica conducts 5-6 rounds to select freshers as Software Engineer in their organisation.
What is the difference between mapping and mapplet in Informatica?
Mapping is developed with different transformation but not reusable. Mapplet can be reused other mapping and also mapplet. Mapping is developed for what data move to target, what modification done upon that. Mapplet is developed for complex calculation used in multiple mappings.
Why do we use mapplet in Informatica?
A mapplet can define source definitions of key data and a source qualifier to provide data for mapping. Mapplet can accept those data also from a mapping process through the mapplet input ports. A mapplet can have multiple transformations. Data can be transformed into multiple pipelines.
How does Informatica improve session performance?
Complete the following tasks to improve session performance:
- Optimize the target.
- Optimize the source.
- Optimize the mapping.
- Optimize the transformation.
- Optimize the session.
- Optimize the grid deployments.
- Optimize the PowerCenter components.
- Optimize the system.