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!

Selecting first 100 rows in source through ODI

Dinesh AtluriJul 16 2014 — edited Jul 22 2014

Hello Everyone,


We are having oracle tables as our source and targets.


We want to pick first 1000 records from source table.


If it is Oracle database,we can simply write query like


SELECT column_name(s) FROM table_name WHERE ROWNUM <= 1000;


How can we do the same thing in ODI ?


Kindly let me your comments.



Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2014
Added on Jul 16 2014
#business-intelligence-applications, #data-integrator, #database, #odi, #oracle, #select, #system-management-and-integration
6 comments
4,715 views