topic Re: [resolved] Guess Schema in Input Component in Talend Studio

[resolved] Guess Schema in Input Component

Anonymous — Tue, 18 Nov 2014 09:18:53 GMT

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.

Re: [resolved] Guess Schema in Input Component

Anonymous — Tue, 18 Nov 2014 10:54:32 GMT

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.
Let me know if this doesn't.
MathurM

Re: [resolved] Guess Schema in Input Component

Anonymous — Tue, 18 Nov 2014 10:57:08 GMT

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