Purpose of Date pattern in Dynamic schema

[Anonymous]

Hi,

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...?

Thanks

[manodwhb]

@kate,have you checked below link?

https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/2...

[Anonymous]

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.