25 Best ETL Interview Questions and Answers

List of top 25 most frequently asked etl interview questions and answers pdf download free

ETL Interview Questions and Answers List

  1. When to use Abort, Decode functions?
  2. What is constraint based loading ?
  3. In a joiner transformation, you should specify the source with fewer rows as the master source. Why?
  4. What is Incremental Aggregation?
  5. What is the default join that source qualifier provides?
  6. What are the options in the target session of update strategy transformations?
  7. Which transformation should we use to normalize the COBOL and relational sources?
  8. What is the use of tracing levels in transformation?
  9. What are the basic needs to join two sources in a source qualifier?
  10. What is update strategy transformation?
  11. Describe two levels in which update strategy transformation sets?
  12. What are the various types of transformation?
  13. What is the difference between active transformation and passive transformation?
  14. What is the use of control break statements?
  15. When to use Abort, Decode functions?
  16. What is constraint based loading ?
  17. Can you start a session within a batch individually?
  18. How can you recognize whether or not the newly added rows in the source are getting inserted in the target?
  19. What are the different options used to configure the sequential batches?
  20. What is a command that used to run a batch?
  21. When the Informatica server marks that a batch is failed?
  22. What is a command that used to run a batch?
  23. To achieve the session partition what are the necessary tasks you have to do?
  24. Why do we use partitioning the session in Informatica?
  25. What are mapping parameters and mapping variables?

This entry was posted in Interview Questions. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *