Hi
I am reading various tables from Oracle each of which contain many date attributes. Is there a transformer that will allow me to filter out all the attributes that are have a type of date as I want to check the dates make sense (I know there are some with some very dodgy data in and wont write out to a sql table)
Thanks
If the Oracle table columns have proper DATE or TIMESTAMP data types, you can query the Oracle metadata tables for the column names using an SQLExecutor. See e.g. https://dataedo.com/kb/query/oracle/find-all-date-and-time-columns
This would make it much easier to know in which columns to look.
Alternatively you can also use the AttributeValidator:
