Multiple input streams into the mapping

David Paras

• November 15, 2013 20:37

I have a  process flow with two of the Data Maps. The first four activities work, but the last three do not produce any records in the database. DS_12347_TW_State generates a record stream and the XSL in the map is nearly identical to the working map above it; however, the database insert produces no records. Is this a problem with sharing the first stream from the ‘incremental’ query? I have tried passing it as a stream to the second Data Map, but still no results.

0

• 

  David Paras

  • November 15, 2013 20:39

  The sequence of stream being passed to the Data Mapping can be checked viewing the Properties of Data Mapping activity inside the Process Designer under property named "source"

  

  In your Data Mapping "DM_12347_TW_QSMQ" there are two Source Schemas "Input_SrcDS_12347_TW_IDs" and "Input_SrcDS_12347_TW_Records" and firstly the stream of second source "DS_12347_TW_Record" is passed to the mapper and then the stream of first source "DS_12347_TW_IDs". Due to which Input of second source is passed to the first schema and input of first source is passed to second schema and the inputs are not valid for the schema's due to which a null output is generated. That is why it is mandatory to pass the stream in expected sequence, so that the next activity receives the correct and expected input.

  0

Post is closed for comments.