Transformation and CTE with Datameer2 followers
Currently I have an ETL pipeline setup using SSIS. What this does it takes a set of files and loads them into a SQL Server. From there we import the data into Datameer.
My question, is I'd like to remove the SQL Server ingestion part. Since Datameer stores data, along with having scheduled import jobs. I'd like to use it as my primary ETL solution.
I do have a few road blocks though. For example, I have 5 data types in a data set that are an amount value but the source system will represent negative values with a trailing negative symbol e.g., ("44.23-") is there anyway within Datameer I can move the trailing symbol the head of the value.
Another operation I perform is CTE using an SQL script. Is there anyway I can perform this in Datameer?