https://community.qlik.com/t5/Talend-Studio/Loading-table-from-one-db-to-other-db/m-p/2361796#M126069 <P>Hi all,</P><P></P><P></P><P>I have a scenario where mssql db having a table of more than 500 columns has to load the table into Teradata. Any Idea/suggestion would be appreciable.</P><P></P><P></P><P>Regards,</P><P>Talend_enth</P> Fri, 15 Nov 2024 23:49:45 GMT Talend_ent 2024-11-15T23:49:45Z https://community.qlik.com/t5/Talend-Studio/Loading-table-from-one-db-to-other-db/m-p/2361796#M126069 <P>Hi all,</P><P></P><P></P><P>I have a scenario where mssql db having a table of more than 500 columns has to load the table into Teradata. Any Idea/suggestion would be appreciable.</P><P></P><P></P><P>Regards,</P><P>Talend_enth</P> Fri, 15 Nov 2024 23:49:45 GMT https://community.qlik.com/t5/Talend-Studio/Loading-table-from-one-db-to-other-db/m-p/2361796#M126069 Talend_ent 2024-11-15T23:49:45Z https://community.qlik.com/t5/Talend-Studio/Loading-table-from-one-db-to-other-db/m-p/2361797#M126070 <P>Hello,</P><P>Which talend solution are you using? Talend open studio or subscription solution?</P><P>Here is a dynamic schema feature in talend subscription solution which allows you to design schema with an unknown column structure (unknown name and number of columns).</P><P>Please refer to this article about: <A href="https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j" alt="https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j" target="_blank">https://community.talend.com/s/article/How-to-process-changing-data-structure-ExK7j</A></P><P>Best regards</P><P>Sabrina</P><P> </P><P> </P> Tue, 31 Aug 2021 05:44:01 GMT https://community.qlik.com/t5/Talend-Studio/Loading-table-from-one-db-to-other-db/m-p/2361797#M126070 Anonymous 2021-08-31T05:44:01Z