Just contact ODI, is achieved by creating an interface implementation oracle two single table synchronization function, the objective understanding to the ODI is an interface can only corresponding to a target list, if you want to sync one hundred tables, that will create one hundred interface, and each interface to manually drag and drop into the map tag, this is very inefficient obviously unreasonable, in the actual demand often have hundreds of thousands of tables need to be synchronized, ODI as a powerful tool for ETL should have a more convenient way of batch processing, but have not seen the current search ODI tutorial how to batch processing way, could you tell me which data ODI friends can help to give directions, thank!!!!!!

CodePudding user response:

Configure the ogg is quite good

CodePudding user response:

Think only ODI to realize the ETL