This figure illustrates the steps in a pipelined data transformation:

Before loading, you start with flat files. After loading, the data is in the table. The difference between pipelined data transformation and multistage data transformation is that pipelined transformation occurs in database tables.