# Procedure

## Procedure

1. Drop the following components from the Palette onto the design workspace: tOracleInput, tMap, and tOracleOutput.
2. Connect the three components using Row Main links. Click the link between tMap and tOracleOutput and name it *leadfact*.

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/Use_Case_tOracleCDC1_1.png)
3. Double-click tOracleInput to display its Basic settings view and define its properties.

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/Use_Case_tOracleCDC1_2.png)
4. Set Property Type to Repository and then select the connection to the *TALEND* database that holds the information about your clients. The connection details will display automatically in the corresponding fields.

   Information noteNote:

   If you have not stored the DB connection details in the Metadata entry in the Repository, select Built-in in the property type list and set the connection details manually.
5. Set Schema to Repository and click the [...] button to select the schema of the *CLIENT* table stored in the Metadata folder.

   Related topics: see *Talend Studio User Guide*.
6. In the Table Name field, enter the name of the table holding the information you want to modify, *CLIENT* in this example.
7. Click Guess Query to retrieve all data from your table.
8. Double-click the tMap component to open the Map Editor. Notice that the input area to the left is already filled with the metadata of the input component.

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/Use_Case_tOracleCDC1_3.png)
9. Drag the fields in the input zone to the fields in the *leadfact* table in the output zone. For more information regarding data mapping, see *Talend Studio User Guide*.
10. Click OK to validate the operation.
11. In the design workspace, double-click tOracleOutput to display its Basic settings view and define its properties.

    ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/Use_Case_tOracleCDC1_4.png)
12. Set Property Type to Repository and then select the *cdc\_data* connection to the data warehouse. The connection details will display automatically in the corresponding fields

    Information noteNote:

    If you have not stored the data warehouse connection details in the Metadata folder in the Repository tree view, select Built-in in the property type list and set the connection details manually.

    Related topics: see *Talend Studio User Guide*.
13. In the Table Name field, enter the name of the table you want to populate with modified data, *LEADFACT* in this example.
14. Save your job and press F6 to create and populate the *LEADFACT* table in the data warehouse.