Consider a use case where you want to read data from the
Customers
table and fetch records of the people who lives in either Santa Cruz or Santa Barbara and concatenate their first and last names. You need to write the full name and city of the customers in Azure Data Warehouse target file.
The following image shows a sample mapping,
m_customer_staging
:
Select the AzureDW_ODBC connection you created to connect to Azure Data Warehouse database and read data from the
Customers
table. Use the Fetching and Concatenation transformations to get the desired output.