AnsweredAssumed Answered

How do I effectively split flat file data for insert / update data to database?

Question asked by calaris on Feb 5, 2018
Latest reply on Feb 6, 2018 by leif_jacobsen

Hi there, I am looking to take a big flat file (50,000 records) and validate whether it exists in a database or not before inserting or updating the data.  I got the document cache to work as a look up, but I seem to be stuck on the routing decisioning.  Everything I looked at indicates that I would need to split the flat file lines into individual documents before I can do routing but that seems super inefficient.

 

I know one option is to do it in stored procedures, but my preference would be to do this inside the boomi process itself...  Both decisioning or routing shapes seem to require parsing out the individual rows into it's own document...

Attachments

Outcomes