I have two data sources (SAP& Salesforce) (No common key).
I want to combine them but with document cache we need a common key which is not there here.
Lets say Object 'A' (SAP BAPI)has two records and Object 'B' (Salesforce )has 3. I want a combination of 3*2= 6 data sets.
A:<1,2> B:<a,b> , i need out put combinations-- <<1,a><1,b> <2,a><2,c>/>
Currently the design is built like Connector A is called, the flow control is Run Each document Individually and dynamic process properties are used to capture elements of object A, then Connector B is called and in the map , the dynamic process properties captured from A are recalled.
Since flow control is restricted to one doc individually, processing time is overly high.
Any ideas on implementing Batching and combining the data sources