ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I'm using the VIP 7.2.0 and I have an Oracle table that want to populate. The UNIQUE KEY should be generated via a sequence (seq0001.nextval). I tested mapping the field with "Sql Function" and put in the SQL command: seq0001.nextval and didn't work. Then I tried with "select seq0001.nextval from dual" and didn't work neither.

How do I populate that field?. My source is an XLS file.

Thanks.

Hello.

Please make sure that your connection type is ORACLE
and set Loading Method to Use Conventional Path

seq0001.nextval is correct syntax

Mike