Lookup Response

Lookup Response is a data flow component for a lookup transformation. For example, Lookup Response in BBDW_FACT_INTERACTIONRESPONSE.dtsx performs a lookup with this SELECT statement:

SELECT RESPONSEDIMID, RESPONSESYSTEMID
FROM BBDW.DIM_RESPONSE

There are two editors for this data flow component. To access the editors for Lookup Response, double-click the Lookup Response data flow component or highlight the component and click Show Advanced Editor or Show Editor. From the Lookup Transformation Editor (Show Editor), you can develop the transformation through drag-and-drop or double-clicks.

You can also edit the transformation through the Advanced Editor using properties.

Lookup Response establishes a connection to a BBDW database and finds exact matches with a SELECT statement. For more information about Lookup Transformations, see Microsoft's MSDN article at Lookup Transformation.