Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Data Quality Guide for Oracle Customer Hub > Configuring Data Quality with Oracle Data Quality Servers > Sample SQL Scripts > IDS_IDT_LOAD_ANY_ENTITY.CMDThe following sample SQL script can be used for incremental data load. NOTE: Use this file for Microsoft Windows. REM ************************************************************************ REM * 1. Change informaticaHome to point to your IIR installation folder * REM * 2. Change initLoadScripts to point to your Initial Load scripts * REM ************************************************************************ NOT %4.==. goto GIvenBatchOnly REM ************************************************************************ REM ************************************************************************ set machineName=%computername% set informaticaHome=C:\InformaticaIR set initLoadScripts=C:\InformaticaIR\InitLoadScripts REM ************************************************************************ REM * Find the number of batches in the current Entity records snapshot * REM ************************************************************************ FOR /F "usebackq delims=!" %%i IN (`sqlplus -s %dbcredentials% @GetBatchCount%1`) DO set xresult=%%i setlocal enabledelayedexpansion REM ************************************************************************ REM * Loop through all the batches * REM ************************************************************************ for /l %%a in (2, 1, !NumBatches!) do ( sqlplus %dbcredentials% @%initLoadScripts%\SetBatchNumber.sql !counter! idsbatch -h%machineName%:1669 -i%initLoadScripts%\idt_%current%_load.txt -1%workdir%\idt_%current%_load!counter!.log -2%workdir%\idt_%current%_load!counter!.err -3%workdir%\idt_%current%_load!counter!.dbg sqlplus %dbcredentials% @%initLoadScripts%\SetBatchNumber.sql %4 idsbatch -h%machineName%:1669 -i%initLoadScripts%\idt_%current%_load.txt -1%workdir%\idt_%current%_load%4.log -2%workdir%\idt_%current%_load%4.err -3%workdir%\idt_%current%_load%4.dbg echo usage "IDS_IDT_LOAD_ANY_ENTITY.CMD <Object_Name> <Work_Dir> <DBUser/DBPassword@TNS_Entry_Name> [Optional Batch Number]" echo e.g. IDS_IDT_LOAD_ANY_ENTITY.CMD ACCOUNT C:\InformaticaIR\InitLoadScripts ora1234/ora1234@ora_db Echo Process completed. Please examine error and log files in %workdir% %%R in (*.err) do if %%~zR neq 0 set /a errorcount += 1 if %errorcount% neq 0 goto batcherror echo %errorcount% batch/es have failed. Please check the following batches: |
![]() ![]() |
Data Quality Guide for Oracle Customer Hub | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |