Interview questions

Informatica interview questions – page 16

484 questions. Tap “Show answer” to check yourself.

  1. What is metadata reporter?

  2. What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing

  3. What is lookup transformation and update strategy transformation and explain with an example.Thanks in Advance

  4. What are the designer tools for creating tranformations?

  5. What are the properties should be notified when we connect the flat file source definition torelational database target definition?

  6. What is Router transformation?

  7. What r the types of lookup caches?

  8. What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?

  9. Can you start a batches with in a batch?

  10. Difference between static cache and dynamic cache?

  11. What is meant by complex mapping

  12. Differences between Informatica 6.2 and Informatica 7.0Yours sincerely

  14. What is the difference between PowerCenter 6 and powercenter 7?

  15. You looking for end to end DW experience? For this, you should have born 15yrs ago. All DW has been implemented, and now maintainance remains

  16. Can you tell me about your project?

  17. How to read line no 10 to line no 15 in Unix from a file?

  18. If we are using a sorter then an aggregate in a mapping and we do not check the check box of sorted input, what will happen?

  19. Lookup tansformation

  20. Railway management system is an example of which kind of e-commerce model?

  21. If you are workflow is running slow in informatica. Where do you start trouble shooting and what are the steps you follow?

  22. Where is the cache stored in informatica?

  23. What is meant by active and passive transformation?

  24. How does the company keep employees excited, innovative, and motivated?

  25. Why spanning tree BPDU filter is used?

  27. What are the types of maping wizards that are to be provided in Informatica?

  28. How i can do incremental aggregation in real time?

  29. Describe two levels in which update strategy transformation sets?

  30. How to Generate the Metadata Reports in Informatica?

  31. What can we do to improve the performance of Informatica Aggregator Transformation?

  32. Would you rather be a jack of many trades or a master of one?

Companies that ask Informatica questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide