Mapping Data Flows in Azure Data Factory by Mark Kromer

Author:Mark Kromer
Language: eng
Format: epub
ISBN: 9781484286128
Publisher: Apress

Cached Lookup

The final source is the LookupMaxKey source that uses the same Azure SQL DB dataset as the ExistingProducts source shown earlier. The difference is that we need to use this source as a way to determine the max key value of the surrogate key, stored in the database column “ProductID”. To get that value, we’ll use the query option on the source transformation using this query where we’ve aliased the max() SQL function to “maxkey” using a SQL query:select max (ProductID) as maxkey from dbo.DimProductsTable

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.