update date of modification, insert date of creation

One Star

update date of modification, insert date of creation

hello,
i want to take champs of a database and i want to insert into a new database.
i want to create 2 champs one for the date of creation, the second for the date of update.
- when i insert a new row, the date of creation is created with the date of the day.
- when i update a row, the date of update is updated with the date of the day.
One Star

Re: update date of modification, insert date of creation

Can you create a stored procedure ?
http://www.talendforge.org/forum/viewtopic.php?id=1077
With Talend it's too slow.
One Star

Re: update date of modification, insert date of creation

how have you selected rows to insert.
i don't understand how you do that...
it easy to selected the rows for the update, it's just a right join but for the row for the insert it's difficult,
can you explain me?
One Star

Re: update date of modification, insert date of creation

With an inner join, rows which match are for the update and inner rejects must be inserted.
One Star

Re: update date of modification, insert date of creation

Hi all,

Can anyone explain the same thing at data model level in MDM.
In the data model I have create date and update date. For both I gave current date as default value. But when I updating the record, create date is also changing to update date. Even I updated the record, the create date rule is also working. How can I get proper dates?
Please help me out in this issue.
Thanks in advance.
Regards,
Lalitha.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch