Implementing Table Loader Transform in BODS

• Table Loaders are used to”Load data to Physical tables”.
• Table Readers are used to “Read data from Table”.

Steps :-

• Go to Project -> Right click on it -> Click on New -> Click on Data flow.

• Enter Data Flow Name and Description.
• Click on Finish.

• Drag and drop  Table Reader into work Area.

• Click on value search help.

• Select our Data source -> Click on OK.

• Click on value search help.

• Select the table.
• Click on OK.

• Click on OK.

• In Work area, we can see our Table Reader.

• Drag and drop  Table Loader into Work Area.

• Click on value search help.

• Select the Destination Data store.
• Click on OK.

• Click on value search help.

• Select the Table and Click on OK.

• Click on OK.

• In Work Area, Now we can see Table loader also.

• Select our source table -> Right click on it -> Click on view data.

• Click on Close.

• Click on Table Loader -> Right click on it -> click on view data.

• In our table loader is initially empty. There is no data in Table Loader.

• Click on Close.

• Link between Table Reader and Table Loader.

• Click on Save.

• Click on validate.

• Click on close.

• Click on Execute.

• Select the Job Server.
• Click on Finish.

• Job executed successfully.

• Select Table loader -> Right click on it -> click on view data.

• Now we can see the data  loaded in Table Loader.