SQL look ups make the hard bits easier! Customers don't always have (in fact rarely) a perfectly formatted source file with all the data you might need. For example you tell a client that for the billing integration you need the customer and their billing address ID. But they do not have the billing address ID in their data.
Continue reading →