We need to migrate data of tables including Teradata to SQL Datawarehouse in Azure cloud.
The tables will also include BLOB/CLOB columns.We are thinking of offloading using 2 steps:
1)Export the data using from Teradata.
2)Upload the data into SQL Datawarehouse
I would like to know if TPT is the best option to achieve point 1 or is there any other option.
If the data is exported from Teradata using TPT will it be possible for the downstream system to process and load the same into SQLDW?
Yes. TPT EXPORT/SELECTOR operator can be used to offload the data from Teradata depending on which downstream tool you are planning to Use.