Meilleur auteur de réponses
I have a file with about 20 000 companies. When I map this file I need to use a .csv-file as a "lookup". I don´t want to use a db lookup, because it will generate 2 requests per each company. What is the best way to do this?
Csv file (containing about 300 rows):
Toutes les réponses
Keep the backup of the csv file in a file location. Use scheduleTask to copy the csv file from this location to a location where BizTalk can read it.
Use parallel convoy orchestration which will pick the source file and the csv file. Create a schema to parse the csv file.
Use map with source as these two inputs and loop through the request, compare if the ID matches, then map the destination. In your case, you xslt to which will be easier to do this map.
A promoted field has to be unique - but you can use anything - so just find a unique field. You may need a custom pipeline to promote something (e.g. part of a filename).If this is helpful or answers your question - please mark accordingly.
Because I get points for it which gives my life purpose (also, it helps other people find answers quickly)