Create a view out of sequence generated that will readily give us the next-sequence. Query this view and assign it to the Create step of the table.
I understand that the view is not supported to be created on Sequence generator in Oracle.
Please following the steps below:
1. Deploy the Data Access Service using the article https://network.informatica.com/videos/2465
Step 2: Execute the SQL below using data Access Service
select seq_name.NEXTVAL from dual;
Step 3: Parse the response from the data access service and input it to create call to insert into the data base.
Please let me know if you have any further questions in this regard.
Your solution works. But it could have been a more straightforward solution. This is a very common requirement I don't know why Informatica does not have a feature to make it work without going through Data Access service.