Mapping Generation Language in OMB (Retrieve and Alter)

For those of you playing with OMB Plus, here is just and example on how to find generation languages in a mapping. Also figured it may be helpful to know (in advance) the results you may get from these queries (including context changes which are required):

OMB+> OMBDCC
/
OMB+> OMBCC 'SAP_DWH_QUICKSTART'
Context changed.
OMB+> OMBCC 'QS_STG'
Context changed.
OMB+> OMBDCC
ORACLE_MODULE /SAP_DWH_QUICKSTART/QS_STG

OMB+> OMBRETRIEVE MAPPING 'STG_COMPANY_MAP' GET PROPERTIES (GENERATION_LANGUAGE)
ABAP

OMB+> OMBRETRIEVE MAPPING 'STG_BILLING_US' GET PROPERTIES (GENERATION_LANGUAGE)
PLSQL

OMB+> OMBRETRIEVE MAPPING 'LOAD_CUST_FILE' GET PROPERTIES (GENERATION_LANGUAGE)
SQLLOADER

Obviously this way you can retrieve all properties, here are some interesting ones for SQL Loader (btw, most people may not know these exist, in the UI you can find them under the Mapping => Configuration menu):

OMB+> OMBRETRIEVE MAPPING 'LOAD_CUST_FILE' GET PROPERTIES (MULTITHREADING)
USE_DEFAULT
OMB+> OMBRETRIEVE MAPPING 'LOAD_CUST_FILE' GET PROPERTIES (OPERATION_RECOVERABLE)
true
OMB+> OMBRETRIEVE MAPPING 'LOAD_CUST_FILE' GET PROPERTIES (CONTINUE_LOAD)
false

And while we are on the topic, here is how you alter a property:

OMB+> OMBALTER MAPPING 'LOAD_CUST_FILE' SET PROPERTIES (CONTINUE_LOAD) VALUES ('true')
Map LOAD_CUST_FILE altered.
OMB+> OMBRETRIEVE MAPPING 'LOAD_CUST_FILE' GET PROPERTIES (CONTINUE_LOAD)
true

Now if you wonder, how does he know the property names? Rather than looking it up I use the following very complex naming algorithm:

  • Look in the configuration UI (in this case for mappings)
  • Find the property you are looking for, for example Continue Load
  • Make it all upper case and substitute spaces with underscores: CONTINUE_LOAD
  • Mostly this works...
And then write your OMB...



Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today