Talend Incremental Counter similar to type1 scd - Logic
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 .
