In this chapter, we explored the Studio processing components and how we can use them to modify the data flows between files, databases, and other start and end points through the use of filters, data sorts, and aggregations. We saw how we could group and un-group data with the Studio normalize and denormalize components. The Studio's tReplace
component is a simple, but hugely useful addition to your toolkit and will undoubtedly find a place in many of your integration jobs. Finally, the ability to extract specific rows from a data flow through the tSampleRow
component was reviewed and we will see examples later in the book where, when combined with a sorting component, this has some powerful applications.
When building integration jobs, you will commonly use the processing components in combination. For example, you might take a data flow from a database, filter out the records you want, then pass the data to a find and replace component, where you will substitute some values with...