Talend Incremental Counter similar to type1 scd - Logic

Anonymous — Thu, 24 Mar 2016 12:58:18 GMT

I have to create a new talend job that creates a new column in target table. I have to implement auto-incremental logic in the job ...
So that I have to get the maximum id plus one every time I insert a value in the table for each time running the job ...
For example , If i run the job first time i have 100 records loaded to target table with max id (key is 100) - (so 100 records inserted)
Next time if i run the job for next set of data's for inserting 10 new or updating 10 old data, my key should be start as 101 to 110 for insert and same key shud be updated again in case of update job... Not again from 1 to 100 ... How to achieve in talend ... can u you suggest me ?
in tmap component can be achieved or which component to be used ? and also whether to use context / variable / expression ?? give me steps to achieve
Note : My Input component is postgresdbinput and output component is tredshiftoutput db . i need to create a new column in redshift DB with the above mentioned requirement .

Re: Talend Incremental Counter similar to type1 scd - Logic

Anonymous — Fri, 25 Mar 2016 03:35:31 GMT

Hi,
We have replied to your another topic: http://community.talend.com:80/t5/Talend-Tech-Internal/Out-of-memory-on-4-2-1-commandline/m-p/4883#M24242
Please stick to one topic so that we can pay individule attention to your issue.
Best regards
Sabrina

topic Re: Talend Incremental Counter similar to type1 scd - Logic in Talend Studio

Talend Incremental Counter similar to type1 scd - Logic

Re: Talend Incremental Counter similar to type1 scd - Logic