January 17, 2014
Today we will discuss how call db sequence from Talend while loading data. For demo purposes we have taken Oracle as our Database.STEPS:
1) Create a sequence in Database using : –create sequence test_seq start with 1 increment by 1;
select test_seq.nextval from dual;
3)Go to Advance Setting Tab of oracle output component and change the settings as defined in the screenshot.
seqence_name.nextval is the command which you have to write in SQL Expression. so that for every row this expression will call your Sequence present at Database Level.