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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema