Question

Finding all date attributes in a table

  • 5 May 2023
  • 1 reply
  • 4 views
markcoopersdc
Rank
Badge +4

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

1 reply

david_r
Rank
Userlevel 4

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:

image

Reply


Community Stats

28,670
Posts
109,366
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.