INFORMATICA INTERVIEW QUESTIONS AND ANSWERS

INFORMATICA MOST ASKED Job Interview Questions. Read INFORMATICA Interview Questions and Answers for Experienced, Freshers PDF Download.

Read INFORMATICA Questions and Answers for Interview

What is target load order?View Answer
Where can we find the throughput option in informatica?View Answer
What is the use of target designer?View Answer
What do you mean by worklet?View Answer
What are the different types of OLAP? Give an example?View Answer
What is OLAP (On-Line Analytical Processing?View Answer
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?View Answer
What are the different tools in workflow manager?View Answer
What is a work flow?View Answer
How can you define user defied event?View Answer
What is predefined event?View Answer
What is meant by pre and post session shell command?View Answer
What is standalone command task?View Answer
What does command task mean?View Answer
Briefly define a session task?View Answer
Which files are created during the session rums by informatics server?View Answer
What are the prerequisite tasks to achieve the session partition?View Answer
What is surrogate key?View Answer
What is the scenario which compels informatica server to reject files?View Answer
What does update strategy mean, and what are the different option of it?View Answer
Briefly define reusable transformation?View Answer
What is a mapplet?View Answer
What is the difference between a connected look up and unconnected look up?View Answer
What do you mean Incremental Aggregation?View Answer
How Union Transformation is used?View Answer
What is Lookup transformation?View Answer
What is Joiner transformation?View Answer
What do you mean by filter transformation?View Answer
Describe Expression transformation?View Answer
Briefly explain the Aggregator transformation?View Answer
How can you validate all mappings in the repository simultaneously?View Answer
Explain the code page compatibility?View Answer
What are the types of metadata that stores in repository?View Answer
How can repository reports be accessed without SQL or other transformations?View Answer
What does role playing dimension mean?View Answer
Briefly describe lookup transformation?View Answer
Explain the use of aggregator cache file?View Answer
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?View Answer
How can one identify whether mapping is correct or not without connecting session?View Answer
What is complex mapping?View Answer
Explain the difference between mapping parameter and mapping variable?View Answer
How many number of sessions can one group in batches?View Answer
Explain sessions. Explain how batches are used to combine executions?View Answer
How are indexes created after completing the load process?View Answer
What is the benefit of partitioning a session?View Answer
How many repositories can be created in informatica?View Answer
What is the difference between a repository server and a powerhouse?View Answer
What is meant by a domain?View Answer
What the difference is between a database, a data warehouse and a data mart?View Answer
What do you mean by Enterprise Data Warehousing?View Answer