Skip to Main Content
Forums

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 map ROWID and ROWNUMBER in ODI

Luiz AraujoJan 29 2010 — edited Dec 29 2010
Hi folks.

I'd like to know how can I map the ROWID and ROWNUMBER using Oracle Database.

Both fields are required in my target table and I need the rowid and rownumber of every record generated on my C$ table.

For instance

Table_Source has 2 fields and 100 records. Table_Target has the same 2 fields of Table_Source, wich is mapped, and 2 more fields, where I need to map them with the ROWID and the ROWNUMBER generated in my C$ table (assuming that I'm using a LKM and IKM on my interface).

Thanks in advance.
Luiz Araujo (a.k.a. Buchu)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2010
Added on Jan 29 2010
#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration
4 comments
3,928 views