Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create unique constraint in ODI

774785Jul 23 2010 — edited Jul 27 2010

Hi

I have view at source side, I want to store source data to target interface table.
For that I need to create UNIQUE constraint at source side to identify the unique records.

I have composite primary key example as follow

desc Test_V;
orderID NUMBER,
itemNumber NUMBER,
productId NUMBER,
quantity NUMBER,
lot_number varchar2(80)

where
PRIMARY KEY (orderID, itemNumber,lot_number);

Some times, lot_number can be null, So, I can't use lot_number in composite key (as per requirement)

Please any body can help me on it

Thanks
Phani

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2010

Added on Jul 23 2010

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

2,151 views