https://community.qlik.com/t5/Talend-Studio/How-to-do-SCD1-for-dynamic-data-type-in-talend/m-p/2310458#M81585 <P>Hi @Prabhakar Sudha​&nbsp;, as you are using a Talend subscribed product you can check if dynamic schema can help you in this task .</P><P>https://help.talend.com/r/en-US/8.0/studio-user-guide-big-data/dynamic-schema</P> Mon, 04 Jul 2022 07:22:23 GMT gjeremy1617088143 2022-07-04T07:22:23Z https://community.qlik.com/t5/Talend-Studio/How-to-do-SCD1-for-dynamic-data-type-in-talend/m-p/2310457#M81584 <P>Hi All,</P><P>​</P><P>I have a scenario where i am getting around 200 feed files from ​source system. All the files are having different metadata.I need to insert records that are not available in MS SQL database and i need to update records that are already available in MS SQL database based on key.I need to create one job to automate this process for all files.</P><P>​</P><P>Did anyone solved this kind of scenario?</P><P>​</P><P>Need help for this problem..</P><P>​</P><P>Note: I am using talend subscription based product .I can create 200 jobs for 200 ​files but it will create a complexity for me in future files count can increase upto 400..</P><P>​</P><P>​</P><P>​</P><P>​</P><P>​</P> Fri, 15 Nov 2024 22:46:42 GMT https://community.qlik.com/t5/Talend-Studio/How-to-do-SCD1-for-dynamic-data-type-in-talend/m-p/2310457#M81584 PS1656525765 2024-11-15T22:46:42Z https://community.qlik.com/t5/Talend-Studio/How-to-do-SCD1-for-dynamic-data-type-in-talend/m-p/2310458#M81585 <P>Hi @Prabhakar Sudha​&nbsp;, as you are using a Talend subscribed product you can check if dynamic schema can help you in this task .</P><P>https://help.talend.com/r/en-US/8.0/studio-user-guide-big-data/dynamic-schema</P> Mon, 04 Jul 2022 07:22:23 GMT https://community.qlik.com/t5/Talend-Studio/How-to-do-SCD1-for-dynamic-data-type-in-talend/m-p/2310458#M81585 gjeremy1617088143 2022-07-04T07:22:23Z