Impossible To Query The Contents Of A Flat File With SQL Instructions From ODI (Sunopsis) ?
(Doc ID 423911.1)
Last updated on OCTOBER 04, 2022
Applies to:Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
After having reverse engineered a Flat File and right-clicked on the ODI (Sunopsis) Datastore in Designer to execute the "Data" menu item, from the SQL button, I wish to:
- modify the SQL instruction by adding a where clause.
- alter the request to a count(*)...where clause.
- sort the Datastore over a certain field.
None of these instructions function correctly. What is going wrong? Is there a work around?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document