Four Stars RSH
Four Stars

[resolved] Guess Schema in Input Component

Dear Team,
Scenario:
I have source query of Sql server which made up of 14 tables ( various left outer join + inner join). I need to select 25 columns from these 14 tables.
Fail in Execution:
I click on "GUESS SCHEMA" but it gives an error. Please refer screenshot
Those errors can be anything.
Requirement:
Its difficult to create schema for those 25 columns manually. Do we have any alternative idea so that Talend himself generate schema for written query ?
Please let me know incase we have any alternative to get schema automatically.
Thanks in advance.
2 REPLIES
One Star

Re: [resolved] Guess Schema in Input Component

Hi RSH,
Its difficult to create schema for those 25 columns manually. Do we have any alternative idea so that Talend himself generate schema for written query ?

I tried this, & successfully achieved it.
So, just a check: Did you put your entire query within "double quotes"? the way Talend expects it.
Hope this helps. Smiley Happy
Let me know if this doesn't.
MathurM
One Star

Re: [resolved] Guess Schema in Input Component

And also, one of the 25 tables should be selected in the 'Table Name' box. (But, I guess, you might be already doing that Smiley Tongue )