How to pass variable to mload

i have a Mload script which I need to run against 35 databases( I have same table in all the 35 database).I need to pass a variable to Mload script so that it will create different set of error tables for each database.this variable is in parameter file (informatica mapping).we have to pass the variable for this parameter file.
sample parameter file
$PMSessionLogFile=$PMRootDir/wms/SessLogs/s_m_WMS_EDW_ADDR_1000.log

$OutputFile_MLoad=$PMRootDir/wms/TgtFiles/ADDR_1000.out

$BadFile_MLoad=$PMRootDir/wms/BadFiles/ADDR_1000.bad

$DBConnection_SOURCE=WMS_SRC_1000

$Param_SOURCE_OWNER=WMSP

$$WH_ID=1000

#$$START_DATE=TO_DATE('09/07/1905','MM/DD/YYYY')

#$$END_DATE=TO_DATE('03/15/2050','MM/DD/YYYY')

$$START_DATE=TRUNC(SYSDATE-1)

$$END_DATE=TRUNC(SYSDATE)

i have append WH_ID for error tables
bhanuyenna
Asked Nov 01, 2010
Edited Nov 01, 2010
Look at the .ACCEPT command.
Rob
Answered Nov 01, 2010

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories