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.