How to create derived columns from other columns using any formula?
As an example, suppose I have a date column following columns along with their values
Date_Of_Birth | May 1, 1965
It should split into -
Day_Of_Birth | 1
Month_Of_Birth | May
Year_Of_Birth | 1965
The new column needs to be derived at an ETL layer and persisted prior to this being loaded into Reltio. As once you want to load data into Reltio you need to map values to attributes.
It is fairly simple to add an additional attribute in Reltio, once the column is derived in the source system.