Guest User

Untitled

a guest
Jun 22nd, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. * Type1
  2. * Type1
  3. * Type2
  4. * Type2
  5. * Type3
  6. * Type4
  7. * Type4
  8.  
  9. * Type1 columns, type2 columns, type3 columns, type4 columns
  10. * Type1 columns, type2 columns, type4 columns
  11.  
  12. * Splitting the original message into messages with records of each type then using a multi-source map to join them up. I had difficultly achieving this as I wasn’t sure what functoids to use.
  13. * Inserting the child records into a SQL database so that the additional columns in the parent records can be populated using SQL lookup functoids. This was a bit slower than I would have hoped and has the additional dependency of using a database.
  14. * Using DTS to load the file, transform it into the format and writing out a file in the joined format for BizTalk to consume. This is simple and fast but isn’t using BizTalk.
Add Comment
Please, Sign In to add comment