Informatica Interview Questions and Answers

Informatica Interview Questions and Answers

Informatica is a software development company.Informatica was founded in 1993. Informatica is headquarters in Redwood City, California. The main Core Products are Data Integration and Enterprise Cloud Data Management

What do you mean by Enterprise Data Warehousing?

What the difference is between a database, a data warehouse and a data mart?

What is meant by a domain?

What is the difference between a repository server and a powerhouse?

What is the benefit of partitioning a session?

How are indexes created after completing the load process?

Explain sessions. Explain how batches are used to combine executions?

How many number of sessions can one group in batches?

Explain the difference between mapping parameter and mapping variable?

Briefly explain the Aggregator transformation?

Describe Expression transformation?

What do you mean by filter transformation?

What is Joiner transformation?

What is Lookup transformation?

How Union Transformation is used?

What do you mean Incremental Aggregation?

What is the difference between a connected look up and unconnected lookup?

What is a mapplet?

Briefly define reusable transformation?

What does update strategy mean, and what are the different option of it?

What is the scenario which compels informatica server to reject files?

What is surrogate key?

What are the prerequisite tasks to achieve the session partition?

Which files are created during the session rums by informatics server?

Briefly define a session task?

What does command task mean?

What is standalone command task?

What is meant by pre and post session shell command?

What is predefined event?

What is complex mapping?

How can one identify whether mapping is correct or not without connecting session?

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

Explain the use of aggregator cache file?

Briefly describe lookup transformation?

What does role playing dimension mean?

How can repository reports be accessed without SQL or other transformations?

What are the types of metadata that stores in repository?

Explain the code page compatibility?

How can you validate all mappings in the repository simultaneously?