Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » If update... if insert ....

#1 2007-07-17 14:48:45

bedurand
Member
Registered: 2007-07-06
Posts: 126

If update... if insert ....

Tags: [database, java, tdboutput]

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

Last edited by bedurand (2007-07-17 15:16:23)

Offline

#2 2007-07-23 15:54:38

bedurand
Member
Registered: 2007-07-06
Posts: 126

Re: If update... if insert ....

The way I use :
I load the table I want to update and I make an inner join between this table and the source table. If it matches it's an update else it's an insert.


Uploaded Images

Offline

#3 2008-02-19 17:43:48

anais
Member
Registered: 2008-01-04
Posts: 49

Re: If update... if insert ....

i have found the solution, i have one job for the insert and an other for the update.
inj the end of the insert, the update run automatically
i have deleted the pb of same name of colonnes


Uploaded Images

Last edited by anais (2008-02-19 17:44:11)

Offline

#4 2008-02-22 00:10:53

Flavio Narvaez F.
Guest

Re: If update... if insert ....

Ok, this solutions are not answers to the problem, they are other ways to do what talend must do with "Action On Data" feature
why it does not work?

Are Talend Offering something that doesn't work?

#5 2008-02-22 00:29:20

mhirt
Talend team
Registered: 2006-09-19
Posts: 1633

Re: If update... if insert ....

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,


Uploaded Images

Offline

#6 2012-06-13 11:10:39

Lalitha
Member
Registered: 2011-02-15
Posts: 35

Re: If update... if insert ....

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.

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » If update... if insert ....

Board footer

Powered by FluxBB