SQL Server Integration Services (SSIS) Part 9 - Lookup Transforms
144.1 هزار بار بازدید -
11 سال پیش
-
If you'd like to help
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andy Brown
https://www.wiseowl.co.uk - Lookup transforms are where Integration Services starts getting fun! They allow you to import sets of data, matching a particular column's value against a "lookup table" and storing the corresponding record id. Not only that, but you can customise what happens when a matching lookup record isn't found, and also use cache transforms to speed up access to your lookup table.
If you like the style of our tutorials but think that there is no substitute for classroom training, we agree with you! Have a look at our two-day SSIS introductory course at https://www.wiseowl.co.uk/courses/ssi... (we'll consider running this in countries outside the UK, although this won't be a cheap option).
By Andy Brown
https://www.wiseowl.co.uk - Lookup transforms are where Integration Services starts getting fun! They allow you to import sets of data, matching a particular column's value against a "lookup table" and storing the corresponding record id. Not only that, but you can customise what happens when a matching lookup record isn't found, and also use cache transforms to speed up access to your lookup table.
If you like the style of our tutorials but think that there is no substitute for classroom training, we agree with you! Have a look at our two-day SSIS introductory course at https://www.wiseowl.co.uk/courses/ssi... (we'll consider running this in countries outside the UK, although this won't be a cheap option).
11 سال پیش
در تاریخ 1392/09/13 منتشر شده
است.
144,155
بـار بازدید شده