22.Teradata Warehouse Builder

Teradata Warehouse Builder

Teradata Warehouse Builder (TWB) is a flexible, high performance data

warehouse loading tool that enables parallel data extraction,

transformation and loading processes common to all data warehouses.

TWB is scalable and enables end-to-end parallelism. The previous

versions of utilities (like FastLoad) allow you to load data into Teradata in

parallel using a single input stream. Teradata Warehouse Builder allows

you to run multiple instances of the extract, optional transformation, and

load. You can have as many loads as you have sources in the same job.

With multiple sources of data coming from multiple platforms, integration is

important in a parallel environment.

Teradata Warehouse Builder eliminates the need for persistent storage. It

stores data into data buffers so you no longer need to write data into a flat

file. Since you don’t need flat files, you no longer need to worry about a

2GB file limit.

Teradata Warehouse Builder provides a single scripting language. You

can do the extract, some transformation, and loads all in one SQL -like

scripting language. Once the dynamics of the language are learned, you

can perform multiple tasks with a single script.

You can use a script converter to convert existing scripts for utilities

(FastLoad, MultiLoad, FastExport and TPump) into Teradata Warehouse

Builder scripts.

Teradata Warehouse Builder supports FastLoad INMODs, FastExport

OUTMODs, and Access Modules to provide access to all the data sources

you use today.