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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema