Since months Pentaho ETL developers have been juggling with three distinct tools- Pentaho DI, SSIS, and PowerShell. Their experience has provided them new perspective on the cons and pros of every tool. In this post, they are sharing their experience with these tools and explain their significance. Before getting started, they first would like to explain ETL in brief and how the tools suits ETL landscape.ETL is Extract Transform Load. Informatica was the initial ETL tool introduced in the mid nineties and continues to be one of the best tools in the market. Why these tools were intended?ETL to...