Advanced Informatica Interview Questions With Answers 2017 | Mindmajix

Informatica Interview Questions

If you're looking for Informatica Interview Questions, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Informatica has a market share of about 29.4%. So, You still have opportunity to move ahead in your career in Informatica. Mindmajix offers advanced Informatica Interview Questions that helps you in cracking your interview & acquire dream career.

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

A teaching set that needs to be implemented to convert data from a source to a target is called a session. Session can be carried out using the session’s manager or pmcmd command. Batch execution can be used to combine sessions executions either in serial manner or in a parallel. Batches can have different sessions carrying forward in  a parallel or serial manner.

 

Q. How many number of sessions can one group in batches?

One can group any number of sessions  but it would be easier for migration if the number of sessions are lesser in a batch.

 

Q. Explain the difference between mapping parameter and mapping variable?

When  values  change during the session’s execution it’s called a mapping variable. Upon completion the Informatica server stores the end value of a variable and is reused when session restarts. Moreover those values that do not change during the sessions execution are called mapping parameters.  Mapping procedure explains mapping parameters and their usage. Values are allocated to these parameters before starting the session.

 

Q. What is complex mapping?

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

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

One can find whether the session is correct or not without connecting the session is with the help of debugging option.

 

Click Here For More Questions: https://mindmajix.com/informatica-interview-questions