Multiple Output Rows from a single Input Row
By StuRamage on Sep 02, 2007
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.