Look up transformation with Full cache Mode Part-2

In the above  connection type please select Cache connection manager. Because it is going to select reference data set in the connection type area. Please find the screen shot below.

 

Now click on Connection option in left hand side. Make sure the cache connection is selected in the drop down. Please find the screen shot below. This connection manager should be same as which we have created in the Cache transform

 

Next click on columns tab. We need to map input column data source to reference dataset. For that we need to select index column from the reference data set. Please find the screen shot.

From the above Input column data source we need to select Product ID that should be map to  reference dataset index column of Product ID. Please find the screen shot below.

In the available reference dataset we need to select one or more column  in which we want look up values. In this case I am going to select Name column from the reference dataset. Please find the screen shot below.

Then click on ok button of Lookup transformation editor.  Then drag the precedence constraints to OLEDB Data destination and connect to data source.  Please find the screen shot below. When you connect the destination from the look up we need to select Lookup match Out put column.

 

Right click on OLEDB Destination click on Edit then please find the attachment here.

 

 

Click on New button. Then please find the screen shot below.

 

Then click on OK Button. Then click on Mapping button. Then click on button. Run