A SQL script, LookupProduct, has been precreated. You can use this script in other resources, for example the sample transformation named getInventoryTransactions.