Advanced Informatica Interview Question & Answers 2017 | Mindmajix

If you are looking for expertise before you enter into the prospective job field, you’ll want to have a series of questions to excel. Get free access to frequently asked Interview Questions with detailed Answers and Explanations. It is perfect for practicing for your next technical job, technical test and support. There are lot of opportunities from many reputed companies in the world. So, You still have opportunity to move ahead in your career in Informatica certification guide. Mindmajix offers advanced Informatica Interview Questions that helps you in cracking your interview & acquire dream career.

What do you mean by Enterprise Data Warehousing?

When the organization data is created at a single point of access it is called as enterprise data warehousing. Data can be provided with a global view to the server via a single source store.  One can do periodic analysis on that same source. It gives better results but however the time required is high.

What is complex mapping?

Following are the features of complex mapping.
1. Difficult requirements
2. Many numbers of transformations
3. Complex business logic

Briefly describe lookup transformation?

Lookup transformations are those transformations which have admission right to RDBMS based data set. The server makes the access faster by using the lookup tables to look  at explicit table data or the database. Concluding data is achieved by matching the look up condition for all look up ports delivered during transformations.

What is Joiner transformation?

Joiner transformation combines two affiliated heterogeneous sources living in different locations while a source qualifier transformation can combine data emerging from a common source.

 

What is Lookup transformation?

It is used for looking up data in a relational table through mapping. Lookup definition from any relational database is imported from a source which has tendency of connecting client and server. One can use multiple lookup transformation in a mapping.

Checkout here for more Informatica Interview Questions: https://mindmajix.com/informatica-interview-questions