Values to be used for Staging Table mapping Keys

Hint: I recommend always mapping the Staging Table keys as numeric value (Leading zero-filled) values to ensure that the multi-threaded functionality in the CC&B batch processes can be utilised as part of your conversion run.
Whilst the mapping tool allows for alphanumeric mappings (or trailing space-filled) it will restrict you to single-threaded instances of all conversion batch tasks.
Where the mapping is dependent on complex mapping of multiple source entities into a single concatenated value, always attempt to ensure that the resulting field is numeric. eg. when concatenating Source Account and Service Identifier (eg. 12345 'Electricity') choose notional numeric values for each service type and zero fill to result in a CC&B staging value of '0012345001' (ie. TO_CHAR(Account_Number || TO_CHAR(DECODE(Service_type,'Electricity','1','Gas','2','Water','3'), '000'), '0000000000')
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Stuart Ramage

I am a Consulting Technical Director for Oracle Corporation, and a member of the OU Black Belt Team, based in Hobart Tasmania.
I have worked in the Utility arena since 1999 on the Oracle UGBU product line, in a variety of roles including Conversion, Technical and Functional Architect.

Contact me on:

Search

Categories
Archives
« April 2015
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