update date of modification, insert date of creation

[Anonymous]

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.

[bdurand]

Can you create a stored procedure ?
https://community.talend.com/t5/Installing-and-Upgrading/If-update-if-insert/td-p/62247
With Talend it's too slow.

[Anonymous]

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?

[bdurand]

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

[Anonymous]

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.