This illustration shows the steps in a pipelined data transformation:

• Load external table with flat files
• Validate customer keys (lookup in customer dimension table)
• Convert source product keys to warehouse product keys
• Insert into the sales warehouse table

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.