In the first post I took a look at some of the challenges we faced within the data warehouse group that we hoped CAST could help us with. In this post, we will take a look at how the challenges were met by CAST.

The Solutions

To address the challenge of maintaining up-to-date, complete and accurate technical documentation of the data warehouse platform, CAST was used to analyze the production platform after every deliverable…

I recently worked with an organization where we had looked at a tool that was able to analyze all the source code for the ETL jobs of their data warehouse and provide several benefits to the organization as a result. The tool is called CAST, and comes from a company called Cast Software. During the presentation of the tool and its features by the CAST team, I was very impressed by what the tool could do in terms of analyzing source code, and even more, what it could do with the information gathered from that analysis …