Talend community forum / Delta loading on tis

etienne5685 · 2012-06-21 18:38:40

Hello world,

I would like to load data from table where the modification date of data are most recent than the last date of the exécution of the job
How i can get the date of logs ??

Regards

pedro · 2012-06-25 05:35:54

Hi

Welcome to Talend Community!

You might use SCD components to distinguish the inserted, updated or deleted time for all data from table.

Regards,
Pedro

etienneAAA · 2012-06-25 11:53:53

Hi,

Thanks for your answer,

How i do this i would like to extract only lines which are modified since the last execution time of my job

exemple : select * from mytable where dt_modified > my_last_job_start_time

thanks

pedro · 2012-06-25 11:56:19

Hi

Which DB do you use?
In SCD component, you might record job start time or scd version. It's the same with your example.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-21 18:38:40

Delta loading on tis

#2 2012-06-25 05:35:54

Re: Delta loading on tis

#3 2012-06-25 11:53:53

Re: Delta loading on tis

#4 2012-06-25 11:56:19

Re: Delta loading on tis

Board footer