Date Datatype data not populated correctly using Dynamic Schem

Highlighted
Six Stars

Date Datatype data not populated correctly using Dynamic Schem

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

 

 


Accepted Solutions
Employee

Re: Date Datatype data not populated correctly using Dynamic Schem

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

Six Stars

Re: Date Datatype data not populated correctly using Dynamic Schem

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


All Replies
Six Stars

Re: Date Datatype data not populated correctly using Dynamic Schem

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

Employee

Re: Date Datatype data not populated correctly using Dynamic Schem

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

Six Stars

Re: Date Datatype data not populated correctly using Dynamic Schem

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Cloud Developer Series – Defining Metadata

This video focuses on different methods of adding metadata to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now