Date Datatype data not populated correctly using Dynamic Schem

[Anonymous]

Hello,

  We have a requirement where we need to generate many flat files from respective source tables in DB.

So we are planning to use Dynamic schema option.

Attached is the Talend flow. We have defined datatype as "Dynamic" with single column in Target file and source as well.

The flow is working fine, but the date field is not populating Timestamp value from DB to File.

Example: Source column in DB has value "

2006-02-15 04:44:00

But in file the date field value is "15-02-2006". So timestamp value is not populated

Can anyone help me in this issue?

thank you

[Anonymous]

Hello Everyone,

  Can anyone please reply to my query regarding Dynamic Schema?

We need to fix the design whether we can go with Dynamic schema design for all tables in single job or we have to design separate jobs for each table to File flow.

Regards,

Rohit

[Anonymous · Accepted solution]

Hi Rohit,

    When you are reading the timestamp from DB, what is the format of the timestamp column? Are you using only date part or are you having both date and time part? Could you please double check it by printing to console using tLogrow?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Hi Nikhil,

  It worked.

In Edit Schema of tDBINPUT component, we have one column with DYNAMIC datatype. There i changed the Date format and loaded the data in file.

It is now taking timestamp as well.

Thank yo for your help.

Regards,

Rohit