Informatica Interview Questions

  1. What r the joiner caches?
  2. How to load time dimension?
  3. What is power center repository?
  4. What is Informatica basic data flow?
  5. Can you start a batches with in a batch?
  6. What is Data Transformation Manager?
  7. What is update strategy transformation?
  8. Where is the cache stored in informatica?
  9. Difference between Rank and Dense Rank?
  10. Why we use stored procedure transformation?
  11. What r the tasks that source qualifier perform?
  12. How do we analyse the data at database level?
  13. What are the join types in joiner transformation?
  14. How i can do incremental aggregation in real time?
  15. Why we use partitioning the session in informatica?
  16. What r the types of groups in Router transformation?
  17. How many types of flat files available in Informatica?
  18. What is the default join that source qualifier provides?
  19. When and how a partition is defined using Informatica?
  20. What is the difference between Informatica 7.0 and 8.0?
  21. What are Dimensions and various types of Dimensions?
  22. What are the designer tools for creating transformations?
  23. What are the unsupported repository objects for a mapplet?
  24. Why did you use stored procedure in your ETL Application?
  25. How many types of dimensions are available in Informatica?
  26. How to get the first 100 rows from the flat file into the target?
  27. How many numbers of sessions that you can create in a batch?
  28. How u will create header and footer in target using informatica?
  29. What is the difference between filter and lookup transformation?
  30. What are the basic needs to join two sources in a source qualifier?
  31. What are two types of processes that informatica runs the session?
  32. What is rank transformation? Where can we use this transformation?
  33. How do you create a mapping using multiple lookup transformation?
  34. How can you improve the performance of Aggregate transformation?
  35. Discuss the advantages & Disadvantages of star & snowflake schema?
  36. What are the different options used to configure the sequential batches?
  37. Which ETL tool is more preferable Informatica or Data Stage and why?
  38. Diff between static and dynamic cache? And please explain with one example?
  39. What is the difference between informatics 7x and 8x and what is latest version?
  40. How do you handle decimal places while importing a flat file into informatica?
  41. How do we do unit testing in informatica? How do we load data in informatica?
  42. Where to store informatica rejected data? How to extract the informatica rejected data?
  43. Why have you applied for an Informatica job? What sort of a career are you aiming for?
  44. What does the expression n filter transformation do in Informatica Slowly growing target wizard?
  45. Whats the diff between Informatica power center server, repository server and repository?
  46. In a joiner transformation, you should specify the source with fewer rows as the master source. Why?
  47. What are main advantages and purpose of using Normalizer Transformation in Informatica?
  48. How can you recognise whether or not the newly added rows in the source are gets insert in the target?
  49. How will u get information about bugs how will u rectify the bugs in real time which tool we are using to rectify the bugs?
  50. In a scenario I want to change the dimensions of a table and normalize the renormalized table which transformation can I use?