How to request Max(Primary Key) from Db and assign to variable in TOS

Anonymous — Mon, 25 Mar 2019 03:43:01 GMT

Hi All,

How can we request Max(PK) from DB and assign to a variable and use this variable in tmap numeric.seq.

If someone can explain this with screenshot on how job to be designed it would be great.

Input table DB-Oracle

Output Table DB-Mysql

Re: How to request Max(Primary Key) from Db and assign to variable in TOS

vapukov — Mon, 25 Mar 2019 04:26:41 GMT

you just need to search! 🙂 all already here!

and you will have a lot of answers to your question:

but, this is not all! 🙂

Talend Team make great work for us - they share demo projects with each Studio! all what we need it just import it:

and go thru all examples:

DEMO project is really Must See before any other future questions, it an excellent resource for studying

another old, but useful resource - https://www.talendbyexample.com/

Take a look! and community members will be happy to help you with many troubles and problem during your tests!

with best regards, Vlad