Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi RSH,
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
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
And also, one of the 25 tables should be selected in the 'Table Name' box. (But, I guess, you might be already doing that
)
)