Orchestrate table import

[sureshabbisetti]

Hi,

Any one clarify me, which is the best method to import meta data i.e. Orchestrate method or Plug-in method. Because I am unable to import the table using Orchestrate schema definitions, but the same table imported using plug-in meta data schema definitions method. I am getting the following error while importing the table using Orchestrate method:
"Could not obtain a schema because prepare failed; the query was: SELECT * FROM Table name".

Thanks in Advance
Suresh

[ray.wurlod]

Orchestrate (via orchdbutil) is usually to be preferred, as it is more accurate.

Can you execute the same SELECT statement via any other client (not DataStage)?