Most applications built with Cognos TM1 require some way to perform data ETL which is an acronym for extract, transform, and load. It is a process that involves extracting data from an outside source, transforming it into some form to fit an operational need, and then loading that newly formatted data into a target.
Cognos TM1 provides TI to meet this requirement. TurboIntegrator or TI gives you the power to develop a process that can recognize an outside data source, pull and transform that data, and then load it into TM1. These processes that you create can be saved and scheduled to run as needed.
In Chapter 3, TurboIntegrator (TI), we covered the basic or fundamental workings of TI and what you need to know to do well when taking the current certification exam. In this chapter, we will reaffirm some of these basics as well as drill deeper into some of the more advanced areas of TI scripting—as it relates to the current certification exam.