I'm using dynamic schema and loading data from Oracle to CSV file.
But in oracle date format is "dd-MM-yyyy hh:mm:ss" but I need "yyyy-MM-dd" in my csv output. I've given the expected dat pattern in dynamic schema as well but its not working.
May I know how date pattern can be changed using dynamic schema ? If not what's a purpose of date pattern in dynamic schema...?
@kate,have you checked below link?
short answer : getting control on field/columns using dynamic data type is not possible during load. So the answer is NO.
But you can achieve this using ELT techniques , after load.