我是ODI 11g的新手,我使用ODI 11g进行开发。到目前为止一切都很好。但是,我想从最终表格中删除最近三个月(etl_date)。我如何使用ODI做到这一点呢?DELETE FROM MYTABLE
WHERE ETL_DATE IN (TO_DATE(#ETL_DATE, 'DDMMYYYY'), ADD_MONTHS(TO_DATE(#ETL_DATE,'DDMMYYYY'), -1), ADD_MONTHS(TO_DATE(#E
log.RECORD_COUNT then 1 else 0 end VALIDATION_RECORD_COUNT_INSERTselect UPPER(substring(QUERY_TEXT,11END_TIME) as Duration_in_secondsfrom VW_QUERY_HISTORY as vw
where substring(QUERY_TEXT,11charindex('from',QUERY_TEXT)-12) like '%JA%'
DOCTYPE etl SYSTEM "http://scriptella.javaforge.com/dtd/etl.dtd"> <description>Scriptella ETL(35:7): The content of element type "etl" must match "(description?/etl/s