ETL Questions

Q1. Explain about ETL testing process.
Q2. Explain about ETL testing strategy.
Q3. Explain about 5 different ETL tools with versions.
Q4. Explain about Informatica and its components.
Q5. How to test ETL process?
Q6. What are the most common issues in ETL Testing?
Q7. Name ten different Informatica transformation and its usage.
Q8. How do you run the Informatica mapping/workflow/session from UNIX?
Q9. How do you connect to database using UNIX?
Q10. Can we automate ETL testing process? If so, how do we do?
Q11. What is the difference between ETL and ELT?
Q12. Describe architecture of ETL?
Q13. Describe one simple example of Transformation rule.
Q14. Describe one complex of Transformation rule.
Q15. Can you give example for Data Validation & Data Transformation?
Q16. What kind of testing you have done using Informatica?
Q17. What is the difference between Integration service and repository services?
Q18. What is the difference between 7.1 and 8.1 in terms of architecture?
Q19. Where to check in Informatica if you get any errors?