<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic How to create multiple parallel jobs for each channels( getting channel id from oracle table) and iterating on each channel_id! in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-create-multiple-parallel-jobs-for-each-channels-getting/m-p/2206392#M6467</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt; 
&lt;P&gt;I am getting distinct channel_id from oracle table, iterating on each channel_id( saving as a context variable) i am setting the URL value and then hitting the REST API for getting the data based on each channel_id. Please see the below image :-&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_Context.PNG" style="width: 925px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8i4.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/154108iD903FA5A3217FF2D/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8i4.png" alt="0683p000009M8i4.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Then setting the URL in tSetGlobalVar --&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_URL.PNG" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8iD.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/137799i9E96F2944B3F87DC/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8iD.png" alt="0683p000009M8iD.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;This job is takes close to 3 hours, how to make different channel_id run in parallel ??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;One thing i am doing is using 4 times iterate when fetching values from tFlowtoIterate to tJavaFlex .&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Iterating.PNG" style="width: 784px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8hQ.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156709i36D1E3BE6DE9D9EB/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8hQ.png" alt="0683p000009M8hQ.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;But When i am fetching the channel_id value from context, later in tmap, its getting wrong channel_id( other columns are correct) may be because context value is changed due to iterate parallel execution.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_tmap_context.PNG" style="width: 479px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8iI.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156268i058C1EA484418B35/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8iI.png" alt="0683p000009M8iI.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;The same tmap Columns is going to DB.&lt;/P&gt; 
&lt;P&gt;Is there any way i can get correct channel_id in my tmap or db ??&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;OR any other way to do parallel execution on channel_id ??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Please help !&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 03:52:45 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T03:52:45Z</dc:date>
    <item>
      <title>How to create multiple parallel jobs for each channels( getting channel id from oracle table) and iterating on each channel_id!</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-create-multiple-parallel-jobs-for-each-channels-getting/m-p/2206392#M6467</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt; 
&lt;P&gt;I am getting distinct channel_id from oracle table, iterating on each channel_id( saving as a context variable) i am setting the URL value and then hitting the REST API for getting the data based on each channel_id. Please see the below image :-&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_Context.PNG" style="width: 925px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8i4.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/154108iD903FA5A3217FF2D/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8i4.png" alt="0683p000009M8i4.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Then setting the URL in tSetGlobalVar --&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_URL.PNG" style="width: 999px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8iD.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/137799i9E96F2944B3F87DC/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8iD.png" alt="0683p000009M8iD.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;This job is takes close to 3 hours, how to make different channel_id run in parallel ??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;One thing i am doing is using 4 times iterate when fetching values from tFlowtoIterate to tJavaFlex .&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Iterating.PNG" style="width: 784px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8hQ.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156709i36D1E3BE6DE9D9EB/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8hQ.png" alt="0683p000009M8hQ.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;But When i am fetching the channel_id value from context, later in tmap, its getting wrong channel_id( other columns are correct) may be because context value is changed due to iterate parallel execution.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Saving_tmap_context.PNG" style="width: 479px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009M8iI.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/156268i058C1EA484418B35/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009M8iI.png" alt="0683p000009M8iI.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;The same tmap Columns is going to DB.&lt;/P&gt; 
&lt;P&gt;Is there any way i can get correct channel_id in my tmap or db ??&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;OR any other way to do parallel execution on channel_id ??&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Please help !&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 03:52:45 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-create-multiple-parallel-jobs-for-each-channels-getting/m-p/2206392#M6467</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T03:52:45Z</dc:date>
    </item>
    <item>
      <title>Re: How to create multiple parallel jobs for each channels( getting channel id from oracle table) and iterating on each channel_id!</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-create-multiple-parallel-jobs-for-each-channels-getting/m-p/2206393#M6468</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;can anyone help me in this, or there is no solution ??&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Mon, 16 Dec 2019 15:49:05 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-create-multiple-parallel-jobs-for-each-channels-getting/m-p/2206393#M6468</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-12-16T15:49:05Z</dc:date>
    </item>
  </channel>
</rss>

