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
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
0

