Oracle Extract using slplus and Load using sql*loader
Oracle Extract using slplus and Load using sql*loader
com.toolsverse.etl.driver.oracle.OracleDriver
EXTRACT_LOAD
drop_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP TABLE config_property_stage;
create_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
create TABLE config_property_stage ( CONFIG_PROPERTY_NUM NUMBER(18), NAME VARCHAR2(255), DESCRIPTION VARCHAR2(255) );
config_property_extract
source
com.toolsverse.etl.core.task.oracle.OracleExtractTask
select CONFIG_PROPERTY_NUM || '|' || NAME || '|' || DESCRIPTION from config_property where upper(name) like upper('%{NAME}%')
load
dest
com.toolsverse.etl.core.task.oracle.OracleLoadTask
LOAD DATA INFILE '{DATA_FOLDER}config_property_extract.dat' APPEND INTO TABLE config_property_stage FIELDS TERMINATED BY "|" trailing nullcols ( CONFIG_PROPERTY_NUM, NAME, DESCRIPTION )
cfg_props
true