topic Re: How to create schema from a query? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-create-schema-from-a-query/m-p/2315079#M85777 Hi,<BR />Have you tried to centralize your oracle database and retrieve table schemas?<BR /><A href="https://help.talend.com/search/all?query=Centralizing+database+metadata" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:Centralizing database metadata</A><BR />Best regards<BR />Sabrina Tue, 09 Aug 2016 10:29:56 GMT Anonymous 2016-08-09T10:29:56Z How to create schema from a query? https://community.qlik.com/t5/Talend-Studio/How-to-create-schema-from-a-query/m-p/2315078#M85776 <P>Hi<BR />As in the diagram, I refer a schema in Repository when creating tOracleInput. When creating the schema, I find that I need to define each column in the schema manually, which takes a while. Is there a way to load the schema from a file or somehow derive it from the result set of a query?<BR />Thanks,<BR />Bin<BR />&nbsp;&nbsp;<BR /><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFa0.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/128095iF64AC95A5FF22795/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFa0.png" alt="0683p000009MFa0.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFYo.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/156529iB7296F840966DA33/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFYo.png" alt="0683p000009MFYo.png" /></span></P> Sat, 16 Nov 2024 10:28:35 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-schema-from-a-query/m-p/2315078#M85776 wangbinlxx 2024-11-16T10:28:35Z Re: How to create schema from a query? https://community.qlik.com/t5/Talend-Studio/How-to-create-schema-from-a-query/m-p/2315079#M85777 Hi,<BR />Have you tried to centralize your oracle database and retrieve table schemas?<BR /><A href="https://help.talend.com/search/all?query=Centralizing+database+metadata" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:Centralizing database metadata</A><BR />Best regards<BR />Sabrina Tue, 09 Aug 2016 10:29:56 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-schema-from-a-query/m-p/2315079#M85777 Anonymous 2016-08-09T10:29:56Z