Five Stars

Purpose of Date pattern in Dynamic schema

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

2 REPLIES
Twelve Stars

Re: Purpose of Date pattern in Dynamic schema

Employee

Re: Purpose of Date pattern in Dynamic schema

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.