I have the ODI version 10.3.5 and I am trying to create a sequence that populates de row_id for a table. The schema is a database.
And I want that this item will be the primary key of the table that is loaded at execute the interface however I'm getting issues.

I have the ODI version 10.3.5 and I am trying to create a sequence that populates de row_id for a table. The schema is a database.
And I want that this item will be the primary key of the table that is loaded at execute the interface however I'm getting issues.

Can you share the issues ? This may help in identifing potential solution .

So please advise me.

If you have a PK which is getting populated by a sequence then keep the following in mind
1. Mapping has to be executed on target
2. You need to un-check UPDATE check box for this column
3. Check not null ( flow control) check box should be un check
4. DISTINCT should not be marked

Restrictions on Sequence Values You cannot use CURRVAL and NEXTVAL in the following constructs:

*•A SELECT statement with the DISTINCT operator*
•A SELECT statement with a GROUP BY clause or ORDER BY clause
•A SELECT statement that is combined with another SELECT statement with the UNION, INTERSECT, or MINUS set operator

Can you please provide the following details :
1. What is the execution area of your sequence ? Is it source or staging or Target.
2. What IKM you are using ( I hope you are executing sequence in Staging or Target ) ?

My understanding is when you check Not Null , all your rows are going to Error table. So it is not giving any error.

When you uncheck the Not Null , it is giving error because Database is not allowing Null values in the Primary Key Column.

You can do the following to check if your sequence is working properly.
Try to write a Insert Select query in DB and execute it and see if it is working properly.