Multiple Output Rows from a single Input Row

Question Received: How do we use the CC&B Conversion Mapping tools to create several rows in a staging table for one row in a source input table? For example, if we have an account with one service in the legacy system, this may be represented by several service agreements in CC&B. We create one CI_ACCT row for the Legacy System Account. We then need to create several CI_SA rows under it.
In some cases we will know the specific details of each row that must be created with a specific type of service eg water usage, drainage.
In other cases we may have an unknown number of rows to create.


Answer: The option of creating multiple input rows in CC&B for a single source row is accomplished by specifying multiple mapping sources (relating to the same input table). I am not sure that I understand how you could have an 'unknown' number of transactions to create, there has to be a business or conversion rule that specifies what records of defined types are required. this will drive the number of mapping sources and the associated column mapping rules for each.
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Stuart Ramage

I am a Consulting Technical Manager 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 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