Hi, We are reading delimited file which contains around 50 attributes in a row. We need to insert this into multiple tables. I have a map in which all the data is loaded. We are using oracle database and each table has primary key which is an oracle sequence. In some tables there are no relation and i can use additional coloumn in advanced settings to use the sequences as primary key. But there are few tables where PK of one table is used as FK in another. I am not sure here how to use Oracle sequence. I know that we can use builtin sequece which comes with TOS, but we can't go with that approach. Is there a way to solve this problem. Any pointers would also be a great help. Thanks in Advance. Regards, Arul.
Thanks for Quick response Shong. I am able to use Oracle Sequence. The problem i am facing is after inserting the first row, i need to fetch the generated oracle sequence and use it to insert into second table. I am looking for inputs to do this. Thanks in advance. Regards, Arul.