Alimentation d'une date de création et de modification

Highlighted
Two Stars

Alimentation d'une date de création et de modification

Bonjour, J'ai besoin d'alimenter dans une table, les champs Datecreate et Datemodify

Datecreate uniquement lorsque c'est un nouvel enregistrement, Datemodify lorsque l'enregistrement existe et seulement s'il est modifié

Le souci, c'est que je n'ai pas ces deux informations dans ma table source ...

Comment puis-je faire ?

Ci-joint, différentes captures d'écran de mon job

 

Hello, I need to fill in in a table, Datecreate and Datemodify fields
Datecreate only when it is a new record, Datemodify when the record exists and only if it is modified
The problem is that I do not have these two informations in my source table ...
How can I do ?
Attached, different screenshots of my job

Fifteen Stars TRF
Fifteen Stars

Re: Alimentation d'une date de création et de modification

As it is an international forum, you should try to ask your questions in english.

Anyway, for your case the better is to use database triggers.


TRF

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now