Informatica Interview Questions For Freshers
  1. What is the difference between a source qualifier and a filter transformation?
  2. How do you handle data loading in Informatica?
  3. What is the difference between a mapping and a session in Informatica?
  4. How do you define a target table in Informatica?
  5. What is the purpose of a lookup transformation in Informatica?
  6. What is a joiner transformation in Informatica?
  7. How do you create a reusable transformation in Informatica?
  8. What is the purpose of a router transformation in Informatica?
  9. How do you troubleshoot errors in an Informatica session?
  10. What is the difference between a connected and unconnected lookup transformation?
  11. How do you handle incremental data loads in Informatica?
  12. How do you handle surrogate keys in Informatica?
  13. What is the purpose of a sequence generator transformation in Informatica?
  14. What is the difference between an aggregator and a sorter transformation in Informatica?
  15. How do you create a source definition in Informatica?
  16. What is a flat file source in Informatica?
  17. What is a session log in Informatica?
  18. How do you create a workflow in Informatica?
  19. What is a mapping designer in Informatica?
  20. What is a repository in Informatica?
  21. How do you create a target definition in Informatica?
  22. What is the difference between a full and incremental data load in Informatica?
  23. How do you handle data validation in Informatica?
  24. How do you use an expression transformation in Informatica?
  25. What is a transformation in Informatica?
  26. What is a data mart in Informatica?
  27. What is a repository manager in Informatica?
  28. What is the purpose of a union transformation in Informatica?
  29. How do you create a session in Informatica?
Informatica Intermediate Interview Questions
  1. How do you handle data quality issues in Informatica?
  2. How do you create a parameter file in Informatica?
  3. What is the purpose of a dynamic lookup transformation in Informatica?
  4. How do you handle slowly changing dimensions in Informatica?
  5. How do you use command tasks in Informatica?
  6. What is the purpose of a pushdown optimization in Informatica?
  7. How do you handle multiple sources in a single mapping in Informatica?
  8. What is the difference between a mapping parameter and a mapping variable in Informatica?
  9. How do you create a session partition in Informatica?
  10. What is the purpose of a pre- and post-session command in Informatica?
  11. What is the difference between a static and dynamic cache in Informatica?
  12. What is the purpose of a non-reusable transformation in Informatica?
  13. How do you use a debugger in Informatica?
  14. How do you handle errors and exceptions in an Informatica session?
  15. What is the purpose of a rank transformation in Informatica?
  16. What is the difference between a mapping and a mapplet in Informatica?
  17. How do you use a dynamic lookup in Informatica?
  18. What is a master source in Informatica?
  19. What is the purpose of a router transformation in Informatica?
  20. How do you use a filter transformation in Informatica?
  21. How do you create a parameter file for a session in Informatica?
  22. What is a workflow monitor in Informatica?
  23. What is the purpose of a merge transformation with sorted input in Informatica?
  24. How do you use a connected and unconnected transformation in Informatica?
  25. What is the difference between a reusable and non-reusable transformation in Informatica?
  26. What is a surrogate key in Informatica?
  27. What is the purpose of a stored procedure transformation in Informatica?
  28. What is a source qualifier transformation in Informatica?
  29. How do you use a rank transformation in Informatica?
  30. What is the purpose of a sequence generator transformation with reset option in Informatica?
Informatica Interview Questions For Experienced
  1. What is the difference between an active and passive transformation in Informatica?
  2. How do you handle multiple targets in a single mapping in Informatica?
  3. What is the purpose of a transaction control transformation in Informatica?
  4. How do you handle FTP file transfers in Informatica?
  5. What is the purpose of a mapping parameter file in Informatica?
  6. What is the difference between a persistent and non-persistent lookup cache in Informatica?
  7. How do you use a debugger in a workflow in Informatica?
  8. What is the purpose of a Java transformation in Informatica?
  9. How do you handle real-time data integration in Informatica?
  10. What is the purpose of a merge transformation in Informatica?
  11. What is the difference between a mapping and mapplet in Informatica?
  12. How do you handle complex data transformations in Informatica?
  13. What is the purpose of a dynamic pipeline partition in Informatica?
  14. How do you use a stored procedure transformation in Informatica?
  15. What is the purpose of a web service transformation in Informatica?
  16. How do you use a custom transformation in Informatica?
  17. What is the difference between a target load plan and a target load order in Informatica?
  18. How do you handle complex business rules in Informatica?
  19. What is the purpose of a constraint-based loading in Informatica?
  20. How do you use a post-processing command in Informatica?
  21. What is the purpose of a pushdown optimization for partitions in Informatica?
  22. How do you use a change data capture (CDC) in Informatica?
  23. What is the purpose of a high precision mode in Informatica?
  24. How do you use a Java transformation with an external library in Informatica?
  25. What is the purpose of a source qualifier override in Informatica?
  26. How do you use a real-time pushdown optimization in Informatica?
  27. What is the difference between a session and a workflow in Informatica?
  28. How do you handle parallel processing in Informatica?
  29. What is the purpose of a normalizer transformation in Informatica?
  30. How do you use a SQL transformation in Informatica?
  31. What is the purpose of a joiner cache in Informatica?
  32. How do you handle dynamic data partitioning in Informatica?
  33. What is the difference between an event-based and time-based schedule in Informatica?
  34. How do you use a flat file target in Informatica?
  35. What is the purpose of a dynamic mapping in Informatica?
  36. How do you use an external loader transformation in Informatica?
  37. What is the purpose of a shortcut in Informatica?
  38. How do you handle complex mappings in Informatica?
  39. What is the purpose of a pre-session and post-session variable assignment in Informatica?
  40. How do you use an XML transformation in Informatica?
  41. What is the purpose of a joiner transformation with sorted input in Informatica?
  42. How do you handle data masking in Informatica?
  43. What is the difference between a persistent and non-persistent dynamic cache in Informatica?
  44. How do you use a parameter file for dynamic mappings in Informatica?
  45. What is the purpose of a worklet in Informatica?