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

Popular posts from this blog

Threading...

Tidy Balances.. I don't really hate it

Increasing batch run throughput