How to create a spread/range of consecutive dates in Azure data factory in derived transformation
I want to create a date spread from 01-01-2005 till 23-01-2015, is it possible to populate such a dates range in the Azure data factory (specifically in mapping data flows). If yes then which function should one use to apply the same. Thank you!Alternative of Money data type in Azure data factory
From an on-premise PostgreSQL DB I am trying to take it as source in the mapping data flow of Azure data factory. In postgreSQL DB table their is a column with values '$22.44', their one can use MONEY datatype. Is their any alternative to MONEY in Azure data factory. I can use string, But that is an incorrect way to import the data. So please recommend any other alternative if available. Thank you!