I am getting error while clicking Guess Schema option in tOracleInput often.
After I write my query inside the Query box of the tOracleInput component, I clicked Guess Schema.
A pop up was displayed saying Connect to DB error, or some errors in SQL query string, or 'Guess Schema' not compatible with current SQL query string.
Then I have checked my DB connection (pointed inside the component), it was successful,
and I tried executing my SQL query string in Oracle developer, it was perfectly executed.
Is there any compatibility for Guess Schema option with respect to SQL query string?
Thanks in advance.
Could you please share your query and component detail screen shot for a quick look? If you are having any functions or column combinations without alias, it might create issue.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.