In the Developer, tool create a Lookup transformation when you want to look up data in a lookup source, such as a flat file or relational table. Specify a lookup condition to determine which rows to retrieve from the lookup source. In this demo, we create a Lookup transformation to determine whether each customer placed an order.