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.
Read the original here:
SmartConnect 2010 Service Pack 1 – SQL Lookups