Hi all, I have a table with columns "INS" and "UP". In action on data in TDBOuput, I choose "Update or insert". But when I insert I don't want to fill UP, and on update I mustn't update INS but fill UP. Is there an easy way to do that (without triggers)? I'm using TOS V2.1.0 with java. Kind regards Ben
These feature has been add since 2.3. Go to your db output component preoperties / advanced settings / Advanced fields option : The Updatable and Insertable columns allows you to choose which fields needs to be inserted and which fields have to be updated Regards,
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.