Select the two correct statements about the Date Profiler.
A.
It can profile string dates written in a variety of formats, such as DD/MM/YYYY or
MM/DD/YYYY.
B.
It provides a distribution for the day in the year, such as February 21, regardless of the year.
C.
It allows the EDQ user to define a valid range of dates.
D.
By clicking a date in blue, the user can drill down to the records that carried that value.
E.
It rejects February 29 as an invalid date.
Explanation:
Ans B D.
A is correct. I tried to pass in input 14/4/2010 at it was treated as Wednesday, April 14, 2010, despite the rest of dates in the same column were provided in MM/DD/YYYY format.
So A, D are correct options.
can you please try passing 12/4/2010 and check whether its December 4th or 12th april 2010 and confirm
BD
B and D
BD.
http://www.oracle.com/webfolder/technetwork/data-quality/edqhelp/Content/processor_library/profiling/date_profiler.htm