OWB 11g Progressive Series

ETL-Create Mappings Use flat file (Flat file) as data source or target source

This article mainly has the following two main aspects:

A with a flat file as the data source, the Oracle database is the target source.

B a flat file as the target source and an Oracle database as a data source.

Before we do this, we need to open our local design center to define and plan our projects as follows:

1 Click to start, select Oracle products, select Warehouse Builder, click Design Center

After you open Design Center, enter the account and the corresponding secret in the following window [oWB 11g Step (1)] and click OK:

Successfully landed design Center, as shown in the picture: