Hi Guys ,
Attached the Pipeline .Please refer in case needed .
I used below process to meet my above requirements .I am using snap.out.totalCount expression to generate the sequence .
First I create 2 table’s in postgres .
This table keeps the track of max of sequence number .
create table Diretory_uniqueid
(
ID integer
);
insert into Diretory_uniqueid values(0);
CREATE TABLE DIRECTORY
(
Prim_Key varchar(200),
Department varchar(200),
Dept_ID integer,
Email varchar(200),
Extensionn varchar(20),
Location varchar(200),
Name varchar(200),
Title varchar(200)
);
this is my main table where prim_key is the key auto increment column .
Below is the snapshot of the Pipeline .
Sequence Generator Pipeline_2019_04_02.slp (19.8 KB)
After load sequence track table shows below :
main table records :
