$Header:$
#!-------------------------------------------------------------------
#! Oracle Warehouse Builder Export Data File  04/23/2004 2:45:10 PM
#!   RELEASE=9.2.0.4.0  OWB REPOSITORY VERSION=9.2.0.2.0
#!   EXPORTUSER=owb  CONNECTSTRING=(DESCRIPTION=(ADDRESS=(HOST=mwiel-lap.us.oracle.com)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl920)))
#!-------------------------------------------------------------------
#
DATASOURCE=OWB
MDLRELEASE=9.2
RELEASE=9.2.0.4.0
FIELDSEPARATOR=|
#
CHARACTERSET=WE8MSWIN1252
#
#Base Language <ISOLanguageID> <LanguageName>
BASELANGUAGE|en_US|American English
#
#Project  <PhysicalName> <LogicalName> <UniversalID> <VersionLabel>
PROJECT|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|null
#
#Location  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <DataSourceFlag> <DataTargetFlag> <FrozenFlag>
LOCATION|WS_TARGET_LOC|WS_TARGET_LOC|8B103F82D0E94CB0B795733BCABF8B61|Oracle Database|9.2|N|N|N|N
#
#Runtime Repository Connection  <PhysicalName> <LogicalName> <UniversalID> <LocType> <LocTypeVersion> <DefaultFlag> <UserName> <Schema> <Host> <Port> <SID>
RUNTIMEREPOSITORYCONNECTION|RTR|RTR|7B7F59DC39A644809C0A15A6348083C3|null|null|N|rtu|rtr|localhost|1521|orcl920
#
#DataWarehouse Installed Module  <PhysicalName> <LogicalName> <UniversalID> <Typecode> <Logical> <CanBeSource> <CanBeHub> <CanBeWarehouse>
#     <Status> <System> <SystemType(SoftwareModuleVersion)> <Integrator> <ApplicationType>
#     <DatabaseLink> <MetadataImported> <ImportTable> <ImportView> <ImportSynonym>
#     <ImportSequence> <Schema> <NameFilter> <ApplyFilter> <MetadataDBLink> <LocationName> <LocationUniversalID>
DATAWAREHOUSE|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATABASE_DICTIONARY.|null|N|Y|Y|DEV_STATUS|null|Oracle Database 8i/9i|Oracle OWB Integrator for Oracle DB and Apps 3.0|Oracle Warehouse Application|null|null|Y|Y|Y|Y|null|null|N|null|WS_TARGET_LOC|8B103F82D0E94CB0B795733BCABF8B61
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.MAINAPP|ora|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.SHORTNAME|wb|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.SCHEMAOWNER|owb|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.CONNECTSTRING|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCSERVER|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCPORT|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.JDBCSERVICENAME|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.APPTOPDIRECTORY|..\..\codegen\|Y|null
CONFIGPARAM|8i.ORACLE8.1.IDENTIFICATION|8i.ORACLE8.1.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.TCLDIRECTORY|tcl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLDIRECTORY|ddl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLEXTENSION|.ddl|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.DDLSPOOLDIRECTORY|ddl\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBDIRECTORY|lib\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBEXTENSION|.lib|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.LIBSPOOLDIRECTORY|lib\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSDIRECTORY|pls\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSEXTENSION|.pls|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.PLSSPOOLDIRECTORY|pls\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPDIRECTORY|abap\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPEXTENSION|.abap|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.ABAPSPOOLDIRECTORY|abap\log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLDIRECTORY|ctl\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLEXTENSION|.ctl|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENDIRECTORIES|8i.ORACLE8.1.CTLRUNPRM|_run.ini|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.RECEIVEDIRECTORY|receive\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.INPUTDIRECTORY|input\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.INVALIDDIRECTORY|invalid\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.WORKDIRECTORY|work\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.SORTDIRECTORY|sort\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.LOGDIRECTORY|log\|Y|null
CONFIGPARAM|8i.ORACLE8.1.RUNTIMEDIRECTORIES|8i.ORACLE8.1.ARCHIVEDIRECTORY|archive\|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENPREFERENCES|8i.ORACLE8.1.GENPREFCRLF|\r\n|Y|null
CONFIGPARAM|8i.ORACLE8.1.GENPREFERENCES|8i.ORACLE8.1.DEPLOYMENTDBTYPE|Oracle9i|Y|null
CONFIGPARAM|8i.ORACLE8.1.DEFAULT_STORAGETABLESPACE|8i.ORACLE8.1.DEFAULT_INDEXTABLESPACE|null|Y|null
CONFIGPARAM|8i.ORACLE8.1.DEFAULT_STORAGETABLESPACE|8i.ORACLE8.1.DEFAULT_OBJECTTABLESPACE|null|Y|null
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|DUAL|DUAL|854265C99D8445AEB36EB21D61C86028|N|N
#
#User Defined Property <PropertyName>
USERDEFINEDPROPERTY|UDP_RESPONSIBILITY|1A0A0EA621544E37B924D3F89E8C1F40
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|DUMMY|DUMMY|787649A74F0941498424DD70C69EDA45|VARCHAR2|1|0|0|N|null|N|N|1
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|83A680BB1B184A6298172BC8E557C8DE|N|N
#
#User Defined Property <PropertyName>
USERDEFINEDPROPERTY|UDP_RESPONSIBILITY|1A0A0EA621544E37B924D3F89E8C1F40
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|CITY|CITY|7864AE620EFD4201B7ED0FEDB1345364|VARCHAR2|50|0|0|N|null|N|N|2
COLUMN|STATE|STATE|40455DF596C94F0DA928AC1F67156865|VARCHAR2|20|0|0|N|null|N|N|3
COLUMN|STREET_ADDRESS|STREET_ADDRESS|ECA10EB519874100B63897E813C236BD|VARCHAR2|50|0|0|N|null|N|N|1
COLUMN|ZIP5|ZIP5|8A69CBDBCCA74D24996110BED83B642B|VARCHAR2|5|0|0|N|null|N|N|4
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|ADDRESS_TABLE|ADDRESS_TABLE|5044570C66B74C0E9B05EC71B3E01AB8|N|N
#
#User Defined Property <PropertyName>
USERDEFINEDPROPERTY|UDP_RESPONSIBILITY|1A0A0EA621544E37B924D3F89E8C1F40
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|CITY|CITY|9B06B28A667840AD951EB658C9D3DBA5|VARCHAR2|50|0|0|N|null|N|N|2
COLUMN|STATE|STATE|73CDFA619C5742B7972A937ABBF7B526|VARCHAR2|20|0|0|N|null|N|N|3
COLUMN|STREET_ADDRESS|STREET_ADDRESS|FB2806AD6C9A42DA963ADDB9F58717DD|VARCHAR2|50|0|0|N|null|N|N|1
COLUMN|ZIP4|ZIP4|6D105542C22741369A1B0388AB12452E|VARCHAR2|4|0|0|N|null|N|N|5
COLUMN|ZIP5|ZIP5|746B079647A943FE9C8C96ACBCFE3A42|VARCHAR2|5|0|0|N|null|N|N|4
#
#Table <PhysicalName> <LogicalName> <UniversalID> <Imported> <Generated>
TABLE|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|6291D1F8BE4D4CDBA67A0C75677C5A0F|N|N
#
#User Defined Property <PropertyName>
USERDEFINEDPROPERTY|UDP_RESPONSIBILITY|1A0A0EA621544E37B924D3F89E8C1F40
#Column <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <Nullable> <DefaultValue> <Imported> <Generated> <Position>
COLUMN|CITY|CITY|B2EA215EC1D741F1A229AE8B7C613F97|VARCHAR2|50|0|0|N|null|N|N|2
COLUMN|STATE|STATE|C33DDE120E9A4A4A934E4D976AC4C627|VARCHAR2|20|0|0|N|null|N|N|3
COLUMN|STREET_ADDRESS|STREET_ADDRESS|A7FB4AF582ED4034A0ED4F6BD201ACE8|VARCHAR2|50|0|0|N|null|N|N|1
COLUMN|ZIP4|ZIP4|F35C3BE0C87542B79E3C0E263AF03B9F|VARCHAR2|4|0|0|N|null|N|N|5
COLUMN|ZIP5|ZIP5|F9CFFBBDE11049E3A927DE1A8C196476|VARCHAR2|5|0|0|N|null|N|N|4
#
STANDALONEPROCEDURE
#
#Transformation <PhysicalName> <LogicalName> <UniversalID> <FunctionIndicator> <ReturnType> <Imported> <Generated> <Signature> <Deterministic> <Parallel Enabled>
FUNCTION|GET_NA|GET_NA|2F22A10FA9C343D0AA057099708EC3B5|N|null|N|N|GET_NA (VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2)|N|N
#Parameter <PhysicalName> <LogicalName> <UniversalID> <DataType> <InputFlag> <OutputFlag> <Position> <OptionalParameter> <DefaultValue>
PARAMETER|P_ADDRESS|P_ADDRESS|0DFCCA87EF3F49E5B75186C12A4D976F|VARCHAR2|N|Y|1|N|null
PARAMETER|P_CITY|P_CITY|3357A263A6114420AFA7837B92F5579D|VARCHAR2|N|Y|2|N|null
PARAMETER|P_STATE|P_STATE|04D99BD116A3429DA4054062EBAAD4FE|VARCHAR2|N|Y|3|N|null
PARAMETER|P_ZIP5|P_ZIP5|282B230A20524D31905C1AC5F8EC7468|VARCHAR2|N|Y|4|N|null
PARAMETER|P_ZIP4|P_ZIP4|B3FBF21A0D5447248F4C51054B6E94B6|VARCHAR2|N|Y|5|N|null
#Implementation <PhysicalName> <LogicalName> <UniversalID> <SoftwareModule> <Language>
IMPLEMENTATION|GET_NA|GET_NA|151FA2ED9C304EDD898A2B774346926B|null|PL/SQL
BEGIN_SYNTAX
  cursor c_address is
  select street_address
  ,      city
  ,      state
  ,      zip5
  ,      zip4
  from   address_table ;

  r_address c_address%rowtype ;

BEGIN

  open  c_address ;
  fetch c_address
  into  r_address ;
  close c_address ;

  p_address := r_address.street_address ;
  p_city    := r_address.city ;
  p_state   := r_address.state ;
  p_zip5    := r_address.zip5 ;
  p_zip4    := r_address.zip4 ;

END;
END_SYNTAX
#
#Transform Category <PhysicalName> <LogicalName> <UniversalID> <CategoryType> <Imported> <Generated>
FUNCTIONCATEGORY|INVOKE_MAP_NA|INVOKE_MAP_NA|5AFF85FF9E20498C85E83CDFD0893446|TYPE_STANDARD|N|N
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TRANSFORMPACKAGES.IDENTIFICATION|8i.TRANSFORMPACKAGES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TRANSFORMPACKAGES.OPTIONS|8i.TRANSFORMPACKAGES.AUTHID|None|Y|null
#
#Transformation <PhysicalName> <LogicalName> <UniversalID> <FunctionIndicator> <ReturnType> <Imported> <Generated> <Signature> <Deterministic> <Parallel Enabled>
FUNCTION|CALL_MAPPING|CALL_MAPPING|71DC9F4013524594B0EDDD271FA2441C|N|null|N|N|CALL_MAPPING (VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2)|N|N
#Parameter <PhysicalName> <LogicalName> <UniversalID> <DataType> <InputFlag> <OutputFlag> <Position> <OptionalParameter> <DefaultValue>
PARAMETER|P_IN_ADDRESS|P_IN_ADDRESS|54EB8C2B9FFC4BBFAC64CF8196CC803D|VARCHAR2|Y|N|1|N|null
PARAMETER|P_IN_CITY|P_IN_CITY|F922C1FA66B640F19F13B12E029C3A0E|VARCHAR2|Y|N|2|N|null
PARAMETER|P_IN_STATE|P_IN_STATE|8BD1919CCE284A97AD50047AE61347CB|VARCHAR2|Y|N|3|N|null
PARAMETER|P_IN_ZIP5|P_IN_ZIP5|557C17331D7744659D26796CA53FA042|VARCHAR2|Y|N|4|N|null
PARAMETER|P_OUT_ADDRESS|P_OUT_ADDRESS|45AD0F19EB9241CF8B5ED509008CF955|VARCHAR2|N|Y|5|N|null
PARAMETER|P_OUT_CITY|P_OUT_CITY|BCE8C8C20A8A43A18F3732AC888C8686|VARCHAR2|N|Y|6|N|null
PARAMETER|P_OUT_STATE|P_OUT_STATE|1A5FC9513462485D894915881D7E088A|VARCHAR2|N|Y|7|N|null
PARAMETER|P_OUT_ZIP5|P_OUT_ZIP5|B3105125A03948D2BAC1B476ED12D9D4|VARCHAR2|N|Y|8|N|null
PARAMETER|P_OUT_ZIP4|P_OUT_ZIP4|EF346B09DB3544FF9672C3790124FD29|VARCHAR2|N|Y|9|N|null
#Implementation <PhysicalName> <LogicalName> <UniversalID> <SoftwareModule> <Language>
IMPLEMENTATION|CALL_MAPPING|CALL_MAPPING|6552BF247CFA43B0A0570F71616675B9|null|PL/SQL
BEGIN_SYNTAX

  l_result number ;
  l_audit_id number ;

begin

  rtr.run_owb_code( l_result
                  , l_audit_id
                  , 'RTR'
                  , 'WS_TARGET_LOC'
                  , 'PLSQL'
                  , 'MAP_NA'
                  , '","'
                  , 'PI_ADDRESS='
                    || p_in_address
                    || ',PI_CITY='
                    || p_in_city
                    || ',PI_STATE='
                    || p_in_state
                    || ',PI_ZIP5='
                    || p_in_zip5
                  ) ;

  if l_result = 1
  then

    dbms_output.put_line('Mapping execution was successful') ;

    p_out_address := rtr.wb_rt_api_exec.get_output_parameter(l_audit_id,'PO_ADDRESS') ;
    p_out_city := rtr.wb_rt_api_exec.get_output_parameter(l_audit_id,'PO_CITY') ;
    p_out_state := rtr.wb_rt_api_exec.get_output_parameter(l_audit_id,'PO_STATE') ;
    p_out_zip5 := rtr.wb_rt_api_exec.get_output_parameter(l_audit_id,'PO_ZIP5') ;
    p_out_zip4 := rtr.wb_rt_api_exec.get_output_parameter(l_audit_id,'PO_ZIP4') ;

  elsif l_result = 2
  then

    dbms_output.put_line('Mapping execution with warning') ;

  else

    dbms_output.put_line('Mapping execution failed') ;

  end if ;

  execute immediate 'alter session set current_schema = rt' ;

end ;
END_SYNTAX
#
DATAWAREHOUSE|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438
#
DATAWAREHOUSE|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438
#
DATAWAREHOUSE|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438
#
CONFIGURABLE|DUAL|DUAL|854265C99D8445AEB36EB21D61C86028|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|false|N|D3B838AEF614478B930038F1A9E6AC19
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|FD28DE9754BE411385E474B8C6B9C4A3
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|83A680BB1B184A6298172BC8E557C8DE|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|ADDRESS_TABLE|ADDRESS_TABLE|5044570C66B74C0E9B05EC71B3E01AB8|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|6291D1F8BE4D4CDBA67A0C75677C5A0F|TABLE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.HSPNUMBER|2|Y|null
CONFIGPARAM|8i.TABLES.PARTITIONING|8i.TABLES.STOREIN|null|Y|null
CONFIGPARAM|8i.TABLES.IDENTIFICATION|8i.TABLES.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TABLES.STORAGESPACE|8i.TABLES.TABLESPACE|null|Y|null
CONFIGPARAM|8i.TABLES.PARALLELISM|8i.TABLES.PARALLEL|PARALLEL|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.LOGGING|LOGGING|Y|null
CONFIGPARAM|8i.TABLES.PERFORMANCEPARAM|8i.TABLES.ESTIMATEPCT|99|Y|null
#
CONFIGURABLE|GET_NA|GET_NA|2F22A10FA9C343D0AA057099708EC3B5|STANDALONEPROCEDURE
#Configuration Parameter  <GroupPhysicalName> <ParamPhysicalName> <ParamValue> <DefaultValue> <UniversalID>
CONFIGPARAM|8i.TRANSFORMATION.IDENTIFICATION|8i.TRANSFORMATION.DEPLOYABLE|true|Y|null
CONFIGPARAM|8i.TRANSFORMATION.OPTIONS|8i.TRANSFORMATION.AUTHID|None|Y|null
#
#Mapping  <PhysicalName> <LogicalName> <UniversalID> <ModulePhysicalName> <ModuleLogicalName> <ModuleUniversalID> <ModuleType>
MAPPING|MAP_NA_BULK|MAP_NA_BULK|DD258F0D2E404D6D8266681A458BD32E|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE
#
#Mapping Stage Component  <PhysicalName> <LogicalName> <UniversalID> <ComponentType> <ReferencedProjectPhysicalName> <ReferencedProjectLogicalName>
#     <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType> <ReferencedFunctionSignature>
MAPPINGSTAGECOMPONENT|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|oracle.wh.service.impl.mapping.component.NameAddress|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_KEY|STRING|0|A142D8F71D3C40DE9A5B9014D35EB780
BEGIN_PROPERTYVALUE
NA_ADDRESSONLY
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_COUNTRY|STRING|0|null
BEGIN_PROPERTYVALUE
NA_USA
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_DUAL_ADDRESS|STRING|0|null
BEGIN_PROPERTYVALUE
NA_DUALADDR_STREET
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS|STRING|0|null
BEGIN_PROPERTYVALUE
NA_NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS_PROCESSOR|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS_LISTNAME|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE1|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE2|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE3|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE4|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|8ADB487E26E14353A6F849B19973BF3A
BEGIN_PROPERTYVALUE
245|24|200|364|0|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INGRP1|INGRP1|17ED62735BFE4B209F401A094CFC5FA2|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PI_ADDRESS|PI_ADDRESS|5FCA615BB14044B5BA5075092D16D268|VARCHAR2|50|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|C05D8B3CFB65487295694C4DFF5845C1
BEGIN_PROPERTYVALUE
NA_PRIMARYADDRESS
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_CITY|PI_CITY|6B79976F9F2E41E8B6C2D57F3E5842E4|VARCHAR2|40|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|CCC9B277C569427C94E9BCF610B0BF22
BEGIN_PROPERTYVALUE
NA_CITY
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_STATE_CODE|PI_STATE_CODE|69A601FA13EE41A0BBCEC5B52AA350D2|VARCHAR2|2|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|26B792FF5D4D434080D5A357266222FD
BEGIN_PROPERTYVALUE
NA_STATE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_ZIP5|PI_ZIP5|74252D6A015C4184A9583E8BF2DD245F|VARCHAR2|5|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|A9BDD2C1E3284040B8A6DD39B8D7D8DF
BEGIN_PROPERTYVALUE
NA_POSTALCODE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|ADDRESS|ADDRESS|A61D9306E0994D3B8A8E2A9749AC3267|VARCHAR2|65|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|973C4BEB58224B5B8E46FB87A15BD66C
BEGIN_PROPERTYVALUE
NA_PRIMARYADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CITY|CITY|6ED9F360328F49C98DAE84A060A636BB|VARCHAR2|50|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|C33A861B0B934283B5FDD1B86C07D922
BEGIN_PROPERTYVALUE
NA_CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|STATE|STATE|80C02C69B6904B16B7B33B8A385D1403|VARCHAR2|20|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|089C6BE385034024BD746311EF60DF5C
BEGIN_PROPERTYVALUE
NA_STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP5|ZIP5|CF842EA2F31B4EF689F1BC9A4588F63F|VARCHAR2|5|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|6C6873E30D474970BBB394CAF6EAEE97
BEGIN_PROPERTYVALUE
NA_ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP4|ZIP4|A32D0C98952044D79EAAF059A0A0708C|VARCHAR2|4|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|C768B90BBBCB4593B150A8F13B9A1D62
BEGIN_PROPERTYVALUE
NA_ZIP4
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|oracle.wh.service.impl.mapping.component.Table|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE|null|null|null|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|6291D1F8BE4D4CDBA67A0C75677C5A0F|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|0BEF770979FA4C71A5D36AA7C288B943
BEGIN_PROPERTYVALUE
ADDRESS_OUT_TABLE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|C506D9BD110C4776B9951C9371907249
BEGIN_PROPERTYVALUE
TRUNCATE_INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|0BFD755F427444C0AC02F3B4DD770EE6
BEGIN_PROPERTYVALUE
483|78|175|239|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|7979BDC9B48C48B5972452D1E21E95DA
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|76A555B7D3DE41ED8448733D54BE9644
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|2185152D691D4072981AEC60E8C511DB
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|F83D5E3C3C394FAA93FD4D85DB507FD7
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|19BA5F42075248628A11BA8759152D4F
BEGIN_PROPERTYVALUE
WS_TARGET
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|8A87DC78395E4ED1BCD7201C63A2D4EC
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|6A3D464B998A4FD58C9B0D83837F2818
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|E2E6CBCFFBE549448C2169408ADD7982
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|78603DC2654B4C32B7D16CB0F175BA69
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|9003D347624F419C884EAAB95EC45D69
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|7C4A8985D1AE43B1B7C97C51CC64DA4E
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|B5C7BF455F4A4952B32A0D3B53CC8188
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|38F903F90BE240C7BC6B2DB484E2D7F0
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|B9CBD8EEA68648359824035255D1AA89
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|STREET_ADDRESS|STREET_ADDRESS|58779C0B077B4D0DB8B3A200081A4925|VARCHAR2|50|0|0|STREET_ADDRESS|STREET_ADDRESS|A7FB4AF582ED4034A0ED4F6BD201ACE8
BEGIN_EXPRESSION
"ADDRESS_OUT_TABLE"."STREET_ADDRESS"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|CD973FE1D1B24F5DA0A547C76EED17B5
BEGIN_PROPERTYVALUE
STREET_ADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|DE74FD322CCC436FA3464789E5C7F132
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|37C122C9696A472EBF21BDFBC1A7A74C
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CITY|CITY|26701310BABE4E6E9E4D82079315E033|VARCHAR2|50|0|0|CITY|CITY|B2EA215EC1D741F1A229AE8B7C613F97
BEGIN_EXPRESSION
"ADDRESS_OUT_TABLE"."CITY"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|6131ED228AA94D49BFECD9BC8B2F2785
BEGIN_PROPERTYVALUE
CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|F2510B7125AC43709DF76002E16C5576
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|0A807B156521446ABB73A28AD9A3EB61
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|STATE|STATE|466F585EFB4446B9886471835819E79F|VARCHAR2|20|0|0|STATE|STATE|C33DDE120E9A4A4A934E4D976AC4C627
BEGIN_EXPRESSION
"ADDRESS_OUT_TABLE"."STATE"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|662EBA635C374096B13BD735FBBD715A
BEGIN_PROPERTYVALUE
STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|DB08C8CDD23C4828B9ABDA284A4BD496
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|273DA360DD904666A080C30FB48E2C2A
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP5|ZIP5|081C94CCFC754D2D9C4389FFD0A28FF4|VARCHAR2|5|0|0|ZIP5|ZIP5|F9CFFBBDE11049E3A927DE1A8C196476
BEGIN_EXPRESSION
"ADDRESS_OUT_TABLE"."ZIP5"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|39079D55F6154747BB5072BBC18BC478
BEGIN_PROPERTYVALUE
ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|6DA959BBACF44D638528F1E1066B118F
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|644A8EA86AF543EE9F1FD1C07420D8EB
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP4|ZIP4|14AA025FB3DD44EF9C6D97E0186E5EAE|VARCHAR2|4|0|0|ZIP4|ZIP4|F35C3BE0C87542B79E3C0E263AF03B9F
BEGIN_EXPRESSION
"ADDRESS_OUT_TABLE"."ZIP4"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|5A8D33140257442B97E3942D845CBFCE
BEGIN_PROPERTYVALUE
ZIP4
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|E5886FA84B6540DD808D8357F84A8E98
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|AA9D20B3B48F404DB0FB6FE510C5CA9A
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|DF1F54809573447C82183361D0ED9221|oracle.wh.service.impl.mapping.component.Table|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE|null|null|null|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|83A680BB1B184A6298172BC8E557C8DE|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|9E76AA267A774E338EC0243A16214E50
BEGIN_PROPERTYVALUE
ADDRESS_IN_TABLE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|4C35E67B823747FBA7809DC78D15BACA
BEGIN_PROPERTYVALUE
25|106|175|220|0|0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|7C18672EBC8F4EB19E47BD45953A9C6F
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|890D7A44031641DABC7B594D5676559A
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|F0995A7D5C6B43C086C2E1DF0A341DD2
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|5CAAE8AA042D4DD89095A5F8D1A584DB
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|5B23CF67F2424CC7A0A0917F2A6B7F10
BEGIN_PROPERTYVALUE
WS_TARGET
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|3C67BB3521F0456CA65221162C89CED0
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|10099EA2A5CC44B18389DF470B149BFB
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|41377251F45C40769FD3054B6B6DAB07
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|4FB60E9704F44AC8A08C7BDF9EF563C5
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|4350749582C24BFBA633086B4C36AA66
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|52B5783A1ED34529BA850BA3BEDB2350
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|C3C36AC509AE44A9A2835E90D9F0F1A6
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|6C622FDC7BA44BADB9D1811836A9C8F1
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|8EFD9DB336734A37A92212BEC749F90C
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|6C9B025666AE4B349AB20BCC267459AE|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|STREET_ADDRESS|STREET_ADDRESS|BD293B6C179A426FB06D316DCC901B28|VARCHAR2|50|0|0|STREET_ADDRESS|STREET_ADDRESS|ECA10EB519874100B63897E813C236BD
BEGIN_EXPRESSION
"ADDRESS_IN_TABLE"."STREET_ADDRESS"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|40596A90BD78475E9DB4A0BC049A3204
BEGIN_PROPERTYVALUE
STREET_ADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|4050A38B940747ECA24F7D936B87B8FF
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|87D9E587A8B547C7B851A77FBED6BB50
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CITY|CITY|5E9B33EF84D7426AAA0F23A73984BD4B|VARCHAR2|50|0|0|CITY|CITY|7864AE620EFD4201B7ED0FEDB1345364
BEGIN_EXPRESSION
"ADDRESS_IN_TABLE"."CITY"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|0AC483F35F364CD3B07B85816B14CA2B
BEGIN_PROPERTYVALUE
CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|E4B3F82E56CC45509240FF48EA45463C
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|4C879489D472454C944D24479C246E8F
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|STATE|STATE|D27DCA8D3EF046039FDFECFFAB90ED75|VARCHAR2|20|0|0|STATE|STATE|40455DF596C94F0DA928AC1F67156865
BEGIN_EXPRESSION
"ADDRESS_IN_TABLE"."STATE"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|8B8BDC5FA88945B8979B8B80C67F7FE5
BEGIN_PROPERTYVALUE
STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|4BE5B269465C4D6C94F9CB73ABF8DC8E
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|0FBDF298FE3A45D3A78086C5529E016B
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP5|ZIP5|790785F376594BDF827196602D3C29E5|VARCHAR2|5|0|0|ZIP5|ZIP5|8A69CBDBCCA74D24996110BED83B642B
BEGIN_EXPRESSION
"ADDRESS_IN_TABLE"."ZIP5"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|12D9D54066FF41A88CD90BC399165157
BEGIN_PROPERTYVALUE
ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|E3453726F530405892DC7107CBB009E8
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|FC29F955EB4F4725BC2940D4EBBE56DF
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
#Mapping Parameter Connection  <TargetStageComponentPhysicalName>  <TargetStageComponentLogicalName> <TargetStageComponentUniversalID>
#     <TargetParameterGroupPhysicalName>  <TargetParameterGroupLogicalName> <TargetParameterGroupUniversalID>
#     <TargetParameterPhysicalName> <TargetParameterLogicalName> <TargetParameterUniversalID> <SourceStageComponentPhysicalName>
#     <SourceStageComponentLogicalName> <SourceStageComponentUniversalID> <SourceParameterGroupPhysicalName> <SourceParameterGroupLogicalName>
#     <SourceParameterGroupUniversalID> <SourceParameterPhysicalName> <SourceParameterLogicalName> <SourceParameterUniversalID>
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|INGRP1|INGRP1|17ED62735BFE4B209F401A094CFC5FA2|PI_ADDRESS|PI_ADDRESS|5FCA615BB14044B5BA5075092D16D268|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|DF1F54809573447C82183361D0ED9221|INOUTGRP1|INOUTGRP1|6C9B025666AE4B349AB20BCC267459AE|STREET_ADDRESS|STREET_ADDRESS|BD293B6C179A426FB06D316DCC901B28
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|INGRP1|INGRP1|17ED62735BFE4B209F401A094CFC5FA2|PI_CITY|PI_CITY|6B79976F9F2E41E8B6C2D57F3E5842E4|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|DF1F54809573447C82183361D0ED9221|INOUTGRP1|INOUTGRP1|6C9B025666AE4B349AB20BCC267459AE|CITY|CITY|5E9B33EF84D7426AAA0F23A73984BD4B
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|INGRP1|INGRP1|17ED62735BFE4B209F401A094CFC5FA2|PI_STATE_CODE|PI_STATE_CODE|69A601FA13EE41A0BBCEC5B52AA350D2|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|DF1F54809573447C82183361D0ED9221|INOUTGRP1|INOUTGRP1|6C9B025666AE4B349AB20BCC267459AE|STATE|STATE|D27DCA8D3EF046039FDFECFFAB90ED75
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|INGRP1|INGRP1|17ED62735BFE4B209F401A094CFC5FA2|PI_ZIP5|PI_ZIP5|74252D6A015C4184A9583E8BF2DD245F|ADDRESS_IN_TABLE|ADDRESS_IN_TABLE|DF1F54809573447C82183361D0ED9221|INOUTGRP1|INOUTGRP1|6C9B025666AE4B349AB20BCC267459AE|ZIP5|ZIP5|790785F376594BDF827196602D3C29E5
MAPPINGPARAMETERCONNECTION|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|STREET_ADDRESS|STREET_ADDRESS|58779C0B077B4D0DB8B3A200081A4925|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|ADDRESS|ADDRESS|A61D9306E0994D3B8A8E2A9749AC3267
MAPPINGPARAMETERCONNECTION|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|CITY|CITY|26701310BABE4E6E9E4D82079315E033|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|CITY|CITY|6ED9F360328F49C98DAE84A060A636BB
MAPPINGPARAMETERCONNECTION|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|STATE|STATE|466F585EFB4446B9886471835819E79F|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|STATE|STATE|80C02C69B6904B16B7B33B8A385D1403
MAPPINGPARAMETERCONNECTION|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|ZIP5|ZIP5|081C94CCFC754D2D9C4389FFD0A28FF4|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|ZIP5|ZIP5|CF842EA2F31B4EF689F1BC9A4588F63F
MAPPINGPARAMETERCONNECTION|ADDRESS_OUT_TABLE|ADDRESS_OUT_TABLE|FB2472FC1FC448299F5458CB16835794|INOUTGRP1|INOUTGRP1|2248C89758254EC194BB7BD9767B217C|ZIP4|ZIP4|14AA025FB3DD44EF9C6D97E0186E5EAE|NAMEADDR|NAMEADDR|3E3A194DD3CC4F259DAA7AC4F5D374FF|OUTGRP1|OUTGRP1|B7C1F190FE554B72B7F9CD375170B566|ZIP4|ZIP4|A32D0C98952044D79EAAF059A0A0708C
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.DEPLOYABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.STEPTYPE|STRING|0|C07EFFA0976B4B5DBF286B268E48A183
BEGIN_PROPERTYVALUE
8i.MAPPINGS.PLSQLSTEP
END_PROPERTYVALUE
#
#
#Physical Mapping Step  <Type> <Name> <Universal ID>
PHYSICALMAPPINGSTEP|8i.MAPPINGS.PLSQLSTEP|Step0|DA49526D517D49DDB5204BBF3AE8024E
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE|STRING|0|null
BEGIN_PROPERTYVALUE
SET_BASED_FAIL_OVER_TO_ROW_BASED
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTBULKSIZE|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL|STRING|0|null
BEGIN_PROPERTYVALUE
ERROR_DETAILS
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTMAXERRORS|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTCOMMITFREQ|INTEGER|0|null
BEGIN_PROPERTYVALUE
1000
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTPURGEGROUP|STRING|0|null
BEGIN_PROPERTYVALUE
wb
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTANALYSISPERCENTAGE|INTEGER|0|null
BEGIN_PROPERTYVALUE
90
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.BULKMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.DEFAULTTABLEFUNCTIONS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.GENERATEANALYZETABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.OPTIMIZERMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.USEHC|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
#Mapping  <PhysicalName> <LogicalName> <UniversalID> <ModulePhysicalName> <ModuleLogicalName> <ModuleUniversalID> <ModuleType>
MAPPING|MAP_NA|MAP_NA|04911702D0C54233AC3006712058BF87|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE
#
#Mapping Stage Component  <PhysicalName> <LogicalName> <UniversalID> <ComponentType> <ReferencedProjectPhysicalName> <ReferencedProjectLogicalName>
#     <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType> <ReferencedFunctionSignature>
MAPPINGSTAGECOMPONENT|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|oracle.wh.service.impl.mapping.component.Filter|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|FILTER.FILTER_CONDITION|STRING|0|73EE391CFBF648CF89CB5B015DBC7ACC
BEGIN_PROPERTYVALUE
1=1
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|B0F592FE6A234414BD305D00C73F00D8
BEGIN_PROPERTYVALUE
89|179|175|244|0|1
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PI_ADDRESS|PI_ADDRESS|B376AE25635140DB9EA76F4F40200C98|VARCHAR2|50|0|0|null|null|null
BEGIN_EXPRESSION
&0
END_EXPRESSION
#
MAPPINGPARAMETER|PI_CITY|PI_CITY|DFA58A7242DD426387F6BDE464E68E9D|VARCHAR2|40|0|0|null|null|null
BEGIN_EXPRESSION
&1
END_EXPRESSION
#
MAPPINGPARAMETER|PI_STATE_CODE|PI_STATE_CODE|8A05338E37534B358C432A4EC11585D4|VARCHAR2|2|0|0|null|null|null
BEGIN_EXPRESSION
&2
END_EXPRESSION
#
MAPPINGPARAMETER|PI_ZIP5|PI_ZIP5|DA912C4284794BB6BA796291E6A8B6EB|VARCHAR2|5|0|0|null|null|null
BEGIN_EXPRESSION
&3
END_EXPRESSION
#
MAPPINGPARAMETER|DUMMY|DUMMY|6C7F105484A140F6BA93AA7D9613A10E|VARCHAR2|1|0|0|null|null|null
BEGIN_EXPRESSION
&4
END_EXPRESSION
#
MAPPINGSTAGECOMPONENT|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|oracle.wh.service.impl.mapping.component.Table|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE|null|null|null|ADDRESS_TABLE|ADDRESS_TABLE|5044570C66B74C0E9B05EC71B3E01AB8|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|75CB64819E79411DB1ED6B3B627023D8
BEGIN_PROPERTYVALUE
ADDRESS_TABLE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|8FA619AD30574AFC895D949F0005B1F2
BEGIN_PROPERTYVALUE
TRUNCATE_INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|8F73F6A1C19745388874A600B02791ED
BEGIN_PROPERTYVALUE
509|177|226|244|0|1
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|790EDC35E9E749DAB898D67EA6FF4AAD
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|B56A1797701143C7A5242C75FD53BF2A
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|C83F3865384F4DD786A67C1B14CFA8BC
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|24BF60B8F4104F9B9CB737D66DF1D0FC
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|1E4A0DE40ADE4D3784EC28E40C522E5D
BEGIN_PROPERTYVALUE
WS_TARGET
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|468BB6B739334581954B7B8279CC0998
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|9A34FF2107B444FC8EF8BA9C8238AB16
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|D8B398C2A1CE4E3CB78808C012DE962E
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|E246B41959A041F3BE9B1C0E555C40B1
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|4B5D34ECDA0C4285B0782B8A175C6857
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|06B50988D8E848DF9C56C109BE68477E
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|7144FA86C1884A57B1094DF76F152E8B
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|03D4603BA5D64A9682E40F54C73263E8
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|F0739718C9AA4D2583B8EA197D74E075
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|STREET_ADDRESS|STREET_ADDRESS|CC3772D940F246BB9794690F54A4313F|VARCHAR2|50|0|0|STREET_ADDRESS|STREET_ADDRESS|FB2806AD6C9A42DA963ADDB9F58717DD
BEGIN_EXPRESSION
"ADDRESS_TABLE"."STREET_ADDRESS"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|A8E45FA919F042A78E283E23AF75EE27
BEGIN_PROPERTYVALUE
STREET_ADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|2A61AB1492BC4E3781657C62AE6FE0FF
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|3F365EEDA0814EE9AFABAA9B17A529FE
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CITY|CITY|355E00364C604D00B6A3979311DF016A|VARCHAR2|50|0|0|CITY|CITY|9B06B28A667840AD951EB658C9D3DBA5
BEGIN_EXPRESSION
"ADDRESS_TABLE"."CITY"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|3FB029B38E4745A4B39DD7BC422973AD
BEGIN_PROPERTYVALUE
CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|87B0883EE6E34A08BF0AD963E0539A10
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|34007FBE6227483FAF8505AD82D0ABAF
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|STATE|STATE|B87F0C8DEB544C77A65C204CC2459809|VARCHAR2|20|0|0|STATE|STATE|73CDFA619C5742B7972A937ABBF7B526
BEGIN_EXPRESSION
"ADDRESS_TABLE"."STATE"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|A2324C2DEB6A4797A95E570A20F6FF11
BEGIN_PROPERTYVALUE
STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|9A03D5D83ADF4218B274DC9E3AB58390
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|30C9A52AB1A34D358577D2D79AFC507F
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP5|ZIP5|E30015E753C14EE880834BF3FB77F377|VARCHAR2|5|0|0|ZIP5|ZIP5|746B079647A943FE9C8C96ACBCFE3A42
BEGIN_EXPRESSION
"ADDRESS_TABLE"."ZIP5"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|85C99BB00F8547A0BDA4751155164178
BEGIN_PROPERTYVALUE
ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|AD5471BC9DCA4CB59A9877F982878E62
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|17363700EF374CC79199EE4811B5AB02
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP4|ZIP4|110D5AB310C942559EC0120EE57529FC|VARCHAR2|4|0|0|ZIP4|ZIP4|6D105542C22741369A1B0388AB12452E
BEGIN_EXPRESSION
"ADDRESS_TABLE"."ZIP4"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|BE348C38610C4EA2853AEAEB7F0EB35D
BEGIN_PROPERTYVALUE
ZIP4
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|4EA9FF99606F40C29B2C188CBEAE65F6
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|4FFFC0604BA64EC99D403B792B591886
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|oracle.wh.service.impl.mapping.component.MappingOutputParameters|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.BOUNDNAME|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|650F0D0690DC4BE6BCAF30B115B26197
BEGIN_PROPERTYVALUE
591|269|196|244|0|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PO_ADDRESS|PO_ADDRESS|A78B611E776B40C68E7068FAC80210E7|VARCHAR2|50|0|0|null|null|null
#
MAPPINGPARAMETER|PO_CITY|PO_CITY|4984972F655F46D3A0F4D3045756E849|VARCHAR2|50|0|0|null|null|null
#
MAPPINGPARAMETER|PO_STATE|PO_STATE|042646C4637B4247A54794D79938CEA3|VARCHAR2|20|0|0|null|null|null
#
MAPPINGPARAMETER|PO_ZIP5|PO_ZIP5|0BD0328AAB134109B5DA84203A69BBAA|VARCHAR2|5|0|0|null|null|null
#
MAPPINGPARAMETER|PO_ZIP4|PO_ZIP4|5413F30BEEA4446EB28D6820340AAE86|VARCHAR2|4|0|0|null|null|null
#
MAPPINGSTAGECOMPONENT|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|oracle.wh.service.impl.mapping.component.PostMapTrigger|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE|null|null|null|GET_NA|GET_NA|2F22A10FA9C343D0AA057099708EC3B5|STANDALONEPROCEDURE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|FUNCTION.FUNCTION_NAME|STRING|0|1DD987F9D0B744B1B791DB06388E258C
BEGIN_PROPERTYVALUE
GET_NA
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|FUNCTION.PROCEDURE_CALL|STRING|0|CDE126351AFD4141A58C82808DE5FBC3
BEGIN_PROPERTYVALUE
GET_NA(OUTGRP1.P_ADDRESS,OUTGRP1.P_CITY,OUTGRP1.P_STATE,OUTGRP1.P_ZIP5,OUTGRP1.P_ZIP4)
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|FUNCTION.IS_PROCEDURE|BOOLEAN|0|A20F6CEEDC454062BA22F9056A5B11D6
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|FUNCTION.POSTMAPPROCESSRUNCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
ON_SUCCESS
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|AE3F383A991946EA940D0EB5EE3E5CAC
BEGIN_PROPERTYVALUE
270|463|187|239|0|1
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|P_ADDRESS|P_ADDRESS|29E877C95D894A11B619411EC76FFA63|VARCHAR2|0|0|0|P_ADDRESS|P_ADDRESS|0DFCCA87EF3F49E5B75186C12A4D976F
BEGIN_EXPRESSION
POSTMAPPING_0_P_ADDRESS
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|BBAA0B4B46C54BECA32FA197D21C0DA6
BEGIN_PROPERTYVALUE
P_ADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|FUNCTION.OUTPUTPARAM.IS_RESULT|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|P_CITY|P_CITY|5C6629F0DD954B658622FFB3C986E2E1|VARCHAR2|0|0|0|P_CITY|P_CITY|3357A263A6114420AFA7837B92F5579D
BEGIN_EXPRESSION
POSTMAPPING_0_P_CITY
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|841FB1A9F65148688BAB946FD240D60E
BEGIN_PROPERTYVALUE
P_CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|FUNCTION.OUTPUTPARAM.IS_RESULT|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|P_STATE|P_STATE|D14DDC1985244C68BD3EDDF563EC314E|VARCHAR2|0|0|0|P_STATE|P_STATE|04D99BD116A3429DA4054062EBAAD4FE
BEGIN_EXPRESSION
POSTMAPPING_0_P_STATE
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|A809325639BF4D9E9E1D581A79FE55A5
BEGIN_PROPERTYVALUE
P_STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|FUNCTION.OUTPUTPARAM.IS_RESULT|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|P_ZIP5|P_ZIP5|9796CD38FAB14C0EB162F24720A495CB|VARCHAR2|0|0|0|P_ZIP5|P_ZIP5|282B230A20524D31905C1AC5F8EC7468
BEGIN_EXPRESSION
POSTMAPPING_0_P_ZIP5
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|4033E8E1B56D45ECA4277CE30B42B1DB
BEGIN_PROPERTYVALUE
P_ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|FUNCTION.OUTPUTPARAM.IS_RESULT|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|P_ZIP4|P_ZIP4|ECF61F43B5FF4A91BF1B505BB20D45F4|VARCHAR2|0|0|0|P_ZIP4|P_ZIP4|B3FBF21A0D5447248F4C51054B6E94B6
BEGIN_EXPRESSION
POSTMAPPING_0_P_ZIP4
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|9B077BC5384A4837AAD416637137CE17
BEGIN_PROPERTYVALUE
P_ZIP4
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|FUNCTION.OUTPUTPARAM.IS_RESULT|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|MAP_INPUTS|MAP_INPUTS|8C0C861FC5F94785853F51566030D564|oracle.wh.service.impl.mapping.component.MappingInputParameters|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.BOUNDNAME|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|53E22476B63D4AC4B191107FAFA0D203
BEGIN_PROPERTYVALUE
15|43|163|216|0|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|75D8C0E371AD4649B6774D68615FB519|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PI_ADDRESS|PI_ADDRESS|67E7FCA0EA7647809CB076464821D3D8|VARCHAR2|50|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|MAPPING_INPUT_PARAMETERS.OUTPUTGROUP.PARAMETER.PROPERTIES.DEFAULT_VALUE|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_CITY|PI_CITY|EC3D7F71730940019A099189277FFC75|VARCHAR2|40|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|MAPPING_INPUT_PARAMETERS.OUTPUTGROUP.PARAMETER.PROPERTIES.DEFAULT_VALUE|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_STATE|PI_STATE|12B29B90130F4B14813B73A5D1CA444C|VARCHAR2|2|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|MAPPING_INPUT_PARAMETERS.OUTPUTGROUP.PARAMETER.PROPERTIES.DEFAULT_VALUE|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_ZIP5|PI_ZIP5|4C3496BA5A15489D9CD09703BA56DE2D|VARCHAR2|5|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|MAPPING_INPUT_PARAMETERS.OUTPUTGROUP.PARAMETER.PROPERTIES.DEFAULT_VALUE|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|DUAL|DUAL|05BBF3F866FB4CF6A09A184425571D3D|oracle.wh.service.impl.mapping.component.Table|WEB_SERVICES|WEB_SERVICES|64FDB5EA2F4545B4BF217348F7AAFDC9|WS_TARGET|WS_TARGET|DB93BAA68AD04367AED26AFC23D10438|DATAWAREHOUSE|null|null|null|DUAL|DUAL|854265C99D8445AEB36EB21D61C86028|TABLE|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|MAPPING.BOUNDNAME|STRING|0|E99DCA3D72F04AF99FFD6BF7C27EA837
BEGIN_PROPERTYVALUE
DUAL
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.DEFAULT.PRIMARY_SOURCE|STRING|0|null
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.LOADTYPE|STRING|0|null
BEGIN_PROPERTYVALUE
INSERT
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.UPDATETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.DELETETARGETCONDITION|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.MATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|DATAENTITY.PARMETERS.ADVANCEDMATCHBYCONSTRAINT|STRING|0|null
BEGIN_PROPERTYVALUE
No constraints
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|98097F66D5D7467295F904CD681DFCA3
BEGIN_PROPERTYVALUE
-43|344|175|171|0|1
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.SCHEMA|STRING|0|9FBB89F13F2F43C4A6DCDB4A9886CE68
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DBLINK|STRING|0|5E0FFC4DFEDB48449A194D69C22E38B2
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.NEW|STRING|0|ED18EAE0FD1E417481D33E3113DBBC11
BEGIN_PROPERTYVALUE
Y
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.METADATA.DBLINK|STRING|0|4C63479F966A468A8EAE486E80EBC9D9
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.OWNER.IM|STRING|0|C14C2D305D744ADFBD811D910200CA0F
BEGIN_PROPERTYVALUE
WS_TARGET
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.USEPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.PARTITIONGRANULARITY|STRING|0|null
BEGIN_PROPERTYVALUE
UNKNOWN
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.DIRECTPEL|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.IGNOREEXISTINGDATA|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXTRACT_HINT|STRING|0|5146CEA894294ADCA0835E241FE11BAC
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.LOAD_HINT|STRING|0|66D92FC8414E45E7B203C22F3B041250
BEGIN_PROPERTYVALUE
APPEND PARALLEL(<TABLE_ALIAS>, DEFAULT, DEFAULT)
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.REENABLECONSTRAINTS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.ENTITY.EXCEPTIONS|STRING|0|04CC1F2D8C0A484BB12F76F1092D9DD2
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.PARTITIONNAME|STRING|0|BE9CB507EF31448C98E6B3F3A45F1E9D
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SUBPARTITIONNAME|STRING|0|73F4A9E0E616469C81C697DEB902E8FF
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SORTEDINDEXES|STRING|0|9FF91372519047DF8BBBB60BAB21831E
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SINGLEROW|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.TRAILINGNULLCOLS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.SKIP|INTEGER|0|null
BEGIN_PROPERTYVALUE
0
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SQLLOADERPARAM.FILE|STRING|0|E40F4F7F55434363AE5CE8D83A18A0E7
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.TABLETYPE|STRING|0|82C181229A6A4FF2A4CB9C9FFF739434
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
PHYSICALSTAGECOMPONENTPROPERTY|8i.MAPPING.TABLE.SAPTABLE.EXTRACTIONMETHOD|STRING|0|9DAD4865E0D64B95B81EB0C044EB23FD
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INOUTGRP1|INOUTGRP1|B33EAA81276941A7A4C5626580C6D1D9|3|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|DUMMY|DUMMY|C79877B60A0C47149E3F9802BD1F8E11|VARCHAR2|1|0|0|DUMMY|DUMMY|787649A74F0941498424DD70C69EDA45
BEGIN_EXPRESSION
"DUAL"."DUMMY"
END_EXPRESSION
MAPPINGPARAMETERPROPERTY|MAPPING.BOUNDNAME|STRING|0|B5887EEF5AE24F76A30013713C76DA4F
BEGIN_PROPERTYVALUE
DUMMY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.INSERTLOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATELOADING|STRING|0|null
BEGIN_PROPERTYVALUE
YES
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEMATCHING|STRING|0|DCB08F30C45843509D3D61AA296957AA
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.UPDATEOPERATION|STRING|0|null
BEGIN_PROPERTYVALUE
=
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|DATAENTITY.INOUTGRP.ATTRIBUTE.DELETEMATCHING|STRING|0|A6FE4B73D7874F86AD8B540EBFD464C6
BEGIN_PROPERTYVALUE
NO
END_PROPERTYVALUE
#
#
MAPPINGSTAGECOMPONENT|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|oracle.wh.service.impl.mapping.component.NameAddress|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null
#
#Mapping Property  <Key> <ValueType> <PropertyLevel> <UniversalID>
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_KEY|STRING|0|F73DAE3B56604037924DD34B1F75A832
BEGIN_PROPERTYVALUE
NA_ADDRESSONLY
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_COUNTRY|STRING|0|null
BEGIN_PROPERTYVALUE
NA_USA
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_DUAL_ADDRESS|STRING|0|null
BEGIN_PROPERTYVALUE
NA_DUALADDR_STREET
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS|STRING|0|null
BEGIN_PROPERTYVALUE
NA_NO
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS_PROCESSOR|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_CASS_LISTNAME|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE1|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE2|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE3|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|NAMEADDRESS_POSTAL_REPORT_ADDRLINE4|STRING|0|null
BEGIN_PROPERTYVALUE
END_PROPERTYVALUE
#
MAPPINGSTAGECOMPONENTPROPERTY|OWBINTERNAL.APPEARANCE|STRING|0|C40F98001EE641CBA18B3B9E602D8885
BEGIN_PROPERTYVALUE
301|16|200|364|0|0
END_PROPERTYVALUE
#
#
#Mapping Stage Component Parameter Group  <PhysicalName> <LogicalName> <UniversalID> <Direction> <ReferencedProjectPhysicalName>
#     <ReferencedProjectLogicalName> <ReferencedProjectUniversalID> <ReferencedModulePhysicalName> <ReferencedModuleLogicalName> <ReferencedModuleUniversalID> 
#     <ReferencedModuleType> <ReferencedCategoryPhysicalName> <ReferencedCategoryLogicalName> <ReferencedCategoryUniversalID>
#     <ReferencedEntityPhysicalName> <ReferencedEntityLogicalName> <ReferencedEntityUniversalID> <ReferencedEntityType>
#     <CurrentDisplaySetPhysicalName> <CurrentDisplaySetLogicalName> <CurrentDisplaySetUniversalID> <CurrentDisplaySetType>
MAPPINGPARAMETERGROUP|INGRP1|INGRP1|C994CC1CA6BC4ADF9F717D0BB23AA606|1|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|PI_ADDRESS|PI_ADDRESS|F69B44EFBDAA40C9AF32794A74654596|VARCHAR2|50|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|628A2098AA234753AE21CBCA3F688F58
BEGIN_PROPERTYVALUE
NA_PRIMARYADDRESS
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_CITY|PI_CITY|50F14A3C73984741A5D26DCC38784DB2|VARCHAR2|40|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|C000C429774441C383BE391B2D47AC45
BEGIN_PROPERTYVALUE
NA_CITY
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_STATE_CODE|PI_STATE_CODE|E81AA80BEF6F49B69F0DF8DBD83DC820|VARCHAR2|2|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|D01BE7235D4A48E5BE0F26B7B7812444
BEGIN_PROPERTYVALUE
NA_STATE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|PI_ZIP5|PI_ZIP5|8F1088215B004DC78DE82F92EDB1721B|VARCHAR2|5|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.INPUTPARAM.DEFAULT_VALUE|STRING|0|6C1C35AE535D42C094D812676E8779B8
BEGIN_PROPERTYVALUE
NA_POSTALCODE
END_PROPERTYVALUE
#
#
MAPPINGPARAMETERGROUP|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|2|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|null|0
#
#Mapping Parameter  <PhysicalName> <LogicalName> <UniversalID> <DataType> <Length> <Precision> <Scale> <ReferencedItemPhysicalName> <ReferencedItemLogicalName> <ReferencedItemUniversalID>
MAPPINGPARAMETER|ADDRESS|ADDRESS|8FA6895BBA4E4E1BAB5239BA62934188|VARCHAR2|65|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|BE1BF1D2FF804D90920CBA0FE5A08E9B
BEGIN_PROPERTYVALUE
NA_PRIMARYADDRESS
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|CITY|CITY|2C8862EBAEC74C60A83BE2230455BCD5|VARCHAR2|50|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|BE995D4B1D564D72A3F643705C670E7E
BEGIN_PROPERTYVALUE
NA_CITY
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|STATE|STATE|46A375E3F94C4B05B98C755596A70BB1|VARCHAR2|20|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|C6D3D8C1F16D4766AB92229A307E927E
BEGIN_PROPERTYVALUE
NA_STATE
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP5|ZIP5|D2031D7D8F3F4B1BB99A291F94BDF3AB|VARCHAR2|5|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|C5A1B8B52C6B452592C72F65DDF965B3
BEGIN_PROPERTYVALUE
NA_ZIP5
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
MAPPINGPARAMETER|ZIP4|ZIP4|F106637FEF6349E4ABF66B6E605BF204|VARCHAR2|4|0|0|null|null|null
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.DEFAULT_VALUE|STRING|0|EC880BC7E6954023B69D883753F8A637
BEGIN_PROPERTYVALUE
NA_ZIP4
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.ADDRESS_TYPE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_ADDRTYPE_NORMAL
END_PROPERTYVALUE
#
MAPPINGPARAMETERPROPERTY|NAMEADDRESS.OUTPUTPARAM.INSTANCE|STRING|0|null
BEGIN_PROPERTYVALUE
NA_INSTANCE_FIRST
END_PROPERTYVALUE
#
#
#Mapping Parameter Connection  <TargetStageComponentPhysicalName>  <TargetStageComponentLogicalName> <TargetStageComponentUniversalID>
#     <TargetParameterGroupPhysicalName>  <TargetParameterGroupLogicalName> <TargetParameterGroupUniversalID>
#     <TargetParameterPhysicalName> <TargetParameterLogicalName> <TargetParameterUniversalID> <SourceStageComponentPhysicalName>
#     <SourceStageComponentLogicalName> <SourceStageComponentUniversalID> <SourceParameterGroupPhysicalName> <SourceParameterGroupLogicalName>
#     <SourceParameterGroupUniversalID> <SourceParameterPhysicalName> <SourceParameterLogicalName> <SourceParameterUniversalID>
MAPPINGPARAMETERCONNECTION|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_ADDRESS|PI_ADDRESS|B376AE25635140DB9EA76F4F40200C98|MAP_INPUTS|MAP_INPUTS|8C0C861FC5F94785853F51566030D564|OUTGRP1|OUTGRP1|75D8C0E371AD4649B6774D68615FB519|PI_ADDRESS|PI_ADDRESS|67E7FCA0EA7647809CB076464821D3D8
MAPPINGPARAMETERCONNECTION|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_CITY|PI_CITY|DFA58A7242DD426387F6BDE464E68E9D|MAP_INPUTS|MAP_INPUTS|8C0C861FC5F94785853F51566030D564|OUTGRP1|OUTGRP1|75D8C0E371AD4649B6774D68615FB519|PI_CITY|PI_CITY|EC3D7F71730940019A099189277FFC75
MAPPINGPARAMETERCONNECTION|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_STATE_CODE|PI_STATE_CODE|8A05338E37534B358C432A4EC11585D4|MAP_INPUTS|MAP_INPUTS|8C0C861FC5F94785853F51566030D564|OUTGRP1|OUTGRP1|75D8C0E371AD4649B6774D68615FB519|PI_STATE|PI_STATE|12B29B90130F4B14813B73A5D1CA444C
MAPPINGPARAMETERCONNECTION|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_ZIP5|PI_ZIP5|DA912C4284794BB6BA796291E6A8B6EB|MAP_INPUTS|MAP_INPUTS|8C0C861FC5F94785853F51566030D564|OUTGRP1|OUTGRP1|75D8C0E371AD4649B6774D68615FB519|PI_ZIP5|PI_ZIP5|4C3496BA5A15489D9CD09703BA56DE2D
MAPPINGPARAMETERCONNECTION|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|DUMMY|DUMMY|6C7F105484A140F6BA93AA7D9613A10E|DUAL|DUAL|05BBF3F866FB4CF6A09A184425571D3D|INOUTGRP1|INOUTGRP1|B33EAA81276941A7A4C5626580C6D1D9|DUMMY|DUMMY|C79877B60A0C47149E3F9802BD1F8E11
MAPPINGPARAMETERCONNECTION|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|STREET_ADDRESS|STREET_ADDRESS|CC3772D940F246BB9794690F54A4313F|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|ADDRESS|ADDRESS|8FA6895BBA4E4E1BAB5239BA62934188
MAPPINGPARAMETERCONNECTION|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|CITY|CITY|355E00364C604D00B6A3979311DF016A|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|CITY|CITY|2C8862EBAEC74C60A83BE2230455BCD5
MAPPINGPARAMETERCONNECTION|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|STATE|STATE|B87F0C8DEB544C77A65C204CC2459809|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|STATE|STATE|46A375E3F94C4B05B98C755596A70BB1
MAPPINGPARAMETERCONNECTION|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|ZIP5|ZIP5|E30015E753C14EE880834BF3FB77F377|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|ZIP5|ZIP5|D2031D7D8F3F4B1BB99A291F94BDF3AB
MAPPINGPARAMETERCONNECTION|ADDRESS_TABLE|ADDRESS_TABLE|776C174017464B12916A58A8B9570F7D|INOUTGRP1|INOUTGRP1|94BB3C5AB91A4A9598CED1733ACC1DB6|ZIP4|ZIP4|110D5AB310C942559EC0120EE57529FC|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|OUTGRP1|OUTGRP1|59AE886D0E0B4832B47BF9D80BCB4825|ZIP4|ZIP4|F106637FEF6349E4ABF66B6E605BF204
MAPPINGPARAMETERCONNECTION|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|PO_ADDRESS|PO_ADDRESS|A78B611E776B40C68E7068FAC80210E7|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|P_ADDRESS|P_ADDRESS|29E877C95D894A11B619411EC76FFA63
MAPPINGPARAMETERCONNECTION|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|PO_CITY|PO_CITY|4984972F655F46D3A0F4D3045756E849|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|P_CITY|P_CITY|5C6629F0DD954B658622FFB3C986E2E1
MAPPINGPARAMETERCONNECTION|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|PO_STATE|PO_STATE|042646C4637B4247A54794D79938CEA3|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|P_STATE|P_STATE|D14DDC1985244C68BD3EDDF563EC314E
MAPPINGPARAMETERCONNECTION|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|PO_ZIP5|PO_ZIP5|0BD0328AAB134109B5DA84203A69BBAA|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|P_ZIP5|P_ZIP5|9796CD38FAB14C0EB162F24720A495CB
MAPPINGPARAMETERCONNECTION|MAP_OUTPUTS|MAP_OUTPUTS|50CD07EAC2E8499CB0DBB38A18713C6F|INGRP1|INGRP1|98C4E59073384143931668A7344FD832|PO_ZIP4|PO_ZIP4|5413F30BEEA4446EB28D6820340AAE86|POSTMAPPING|POSTMAPPING|7F691DB03B364E6DB0127948B4849790|OUTGRP1|OUTGRP1|222335C745E24E1A92A6066FF875F08A|P_ZIP4|P_ZIP4|ECF61F43B5FF4A91BF1B505BB20D45F4
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|INGRP1|INGRP1|C994CC1CA6BC4ADF9F717D0BB23AA606|PI_ADDRESS|PI_ADDRESS|F69B44EFBDAA40C9AF32794A74654596|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_ADDRESS|PI_ADDRESS|B376AE25635140DB9EA76F4F40200C98
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|INGRP1|INGRP1|C994CC1CA6BC4ADF9F717D0BB23AA606|PI_CITY|PI_CITY|50F14A3C73984741A5D26DCC38784DB2|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_CITY|PI_CITY|DFA58A7242DD426387F6BDE464E68E9D
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|INGRP1|INGRP1|C994CC1CA6BC4ADF9F717D0BB23AA606|PI_STATE_CODE|PI_STATE_CODE|E81AA80BEF6F49B69F0DF8DBD83DC820|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_STATE_CODE|PI_STATE_CODE|8A05338E37534B358C432A4EC11585D4
MAPPINGPARAMETERCONNECTION|NAMEADDR|NAMEADDR|4BC4EC414F1F43F881376197A6C72B15|INGRP1|INGRP1|C994CC1CA6BC4ADF9F717D0BB23AA606|PI_ZIP5|PI_ZIP5|8F1088215B004DC78DE82F92EDB1721B|FLTR|FLTR|090962D3B57047C39257A342AE7780DA|INOUTGRP1|INOUTGRP1|FC89F30A595345B7B85CC56C695AEF26|PI_ZIP5|PI_ZIP5|DA912C4284794BB6BA796291E6A8B6EB
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.DEPLOYABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
MAPPINGPHYSICALPROPERTY|8i.MAPPINGS.STEPTYPE|STRING|0|4B93ECD519184F92A4D6252EC7ECAC07
BEGIN_PROPERTYVALUE
8i.MAPPINGS.PLSQLSTEP
END_PROPERTYVALUE
#
#
#Physical Mapping Step  <Type> <Name> <Universal ID>
PHYSICALMAPPINGSTEP|8i.MAPPINGS.PLSQLSTEP|Step0|A9F7A65072704CA89DFE32E5CE24C53A
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTOPERATINGMODE|STRING|0|null
BEGIN_PROPERTYVALUE
SET_BASED_FAIL_OVER_TO_ROW_BASED
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTBULKSIZE|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTAUDITLEVEL|STRING|0|null
BEGIN_PROPERTYVALUE
ERROR_DETAILS
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTMAXERRORS|INTEGER|0|null
BEGIN_PROPERTYVALUE
50
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTCOMMITFREQ|INTEGER|0|null
BEGIN_PROPERTYVALUE
1000
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTPURGEGROUP|STRING|0|null
BEGIN_PROPERTYVALUE
wb
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.RUNTIMEPARAMS.DEFAULTANALYSISPERCENTAGE|INTEGER|0|null
BEGIN_PROPERTYVALUE
90
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.BULKMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.DEFAULTTABLEFUNCTIONS|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.GENERATEANALYZETABLE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.OPTIMIZERMODE|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
true
END_PROPERTYVALUE
#
PHYSICALMAPPINGSTEPPROPERTY|8i.MAPPINGS.PLSQLSTEP.CODEGENERATIONPARAMS.USEHC|BOOLEAN|0|null
BEGIN_PROPERTYVALUE
false
END_PROPERTYVALUE
#
#
#!----------------------------------------------------------------------
#! End Oracle Warehouse Builder Export Data File  04/23/2004 2:45:19 PM
#!----------------------------------------------------------------------
#! OWB MetaData Loader Statistics
#! 
#! 
#!Counts for OWB Export Utility
#!-----------------------------
#! 
#!Total Projects Processed by Export = 1
#! 
#! 
#!-------------------------------
#!Project = WEB_SERVICES
#! 
#!       Entity in Project             Added
#!-------------------------------      -----
#!                 DATAWAREHOUSE:          1
#!                         TABLE:          4
#!                        COLUMN:         15
#!              FUNCTIONCATEGORY:          1
#!                      FUNCTION:          2
#!                     PARAMETER:         14
#!                IMPLEMENTATION:          2
#!                       MAPPING:          2
#!         MAPPINGSTAGECOMPONENT:         10
#! MAPPINGSTAGECOMPONENTPROPERTY:         65
#!PHYSICALSTAGECOMPONENTPROPERTY:         88
#!         MAPPINGPARAMETERGROUP:         12
#!              MAPPINGPARAMETER:         52
#!      MAPPINGPARAMETERPROPERTY:        142
#!    MAPPINGPARAMETERCONNECTION:         28
#!       MAPPINGPHYSICALPROPERTY:          4
#!           PHYSICALMAPPINGSTEP:          2
#!   PHYSICALMAPPINGSTEPPROPERTY:         24
#!                   CONFIGPARAM:         70
#!           USERDEFINEDPROPERTY:          4
#!                      LOCATION:          1
#!   RUNTIMEREPOSITORYCONNECTION:          1