根据下面两条要求写一个cmd脚本,在Informatica中用,数据库用的是sql server,我分析了下,这是关于批处理的,谁有高见,给写一下。目前没有进展,对脚本不熟,又急着用。
As soon as the daily batch starts, one initial job will insert a set of rows into the ETL_JOB_RUN table from ETL_JOB_MASTER. It will also update the PARAMETER table to update the BATCH_ID and the current system date.
For each mapping run, ETL_JOB_RUN will be updated with start/end time, and read/update/reject record count