By default the maximum number of errors in a mapping is 50..... Here is a script to change it to 0:
############################################################
# #
# Change Maximum Number Of Errors #
# #
# (C) Ciber Nederland John Minkjan #
# http:\\OMB101.blogspot.com #
# V001 Init Version #
# V002 Validated against OWB11gR2 #
# orignal idea: Borkur Steingrimsson #
# #
############################################################
#Disconnect if connected
catch {
OMBDISCONNECT;
};
OMBCONNECT OWB_OWN/******@***********:1521:DWH_A2
set OMBPROMPT ON
set projectList [OMBLIST PROJECTS]
foreach projectName $projectList {
OMBCC '$projectName'
puts "Project: $projectName"
set moduleList [OMBLIST ORACLE_MODULES]
foreach moduleName $moduleList {
puts "Process: $moduleName"
OMBCC '$moduleName'
set mappingList [OMBLIST MAPPINGS]
foreach mappingName $mappingList {
puts "Altering: $moduleName/$mappingName"
OMBALTER MAPPING '$mappingName' SET PROPERTIES (MAXIMUM_NUMBER_OF_ERRORS) VALUES ('0')
};
OMBCC '..'
};
OMBCC '..'
};
(Kudos to Borkur: http://www.rittmanmead.com/2007/07/a-little-bit-of-omb-goes-a-long-way/)
Till Next Time
No comments:
Post a Comment