Impossible To Query the Contents of a Flat File with SQL Instructions from ODI (Sunopsis)
(Doc ID 423911.1)
Last updated on DECEMBER 18, 2023
Applies to:
Oracle Data Integrator - Version 3.2.03.01 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
After having reverse engineered a Flat File and right-clicked on the Oracle Data Integrator (ODI) (Sunopsis) Datastore in Designer to execute the "Data" menu item, from the SQL button, how 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?
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |