Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Performance Tuning Guidelines for Full Pushdown Optimization for Microsoft Azure SQL Data Warehouse Connector

Performance Tuning Guidelines for Full Pushdown Optimization for Microsoft Azure SQL Data Warehouse Connector

Create a Mapping

Create a Mapping

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.

0 COMMENTS

We’d like to hear from you!