<?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 Talend Testing (error catch) in Data Quality</title>
    <link>https://community.qlik.com/t5/Data-Quality/Talend-Testing-error-catch/m-p/2268605#M2379</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;We are using Talend for data processing. At the moment we are at the stage of reading input csv files.&lt;/P&gt;
&lt;P&gt;We need to check the design for data quality: does the system capable of identifying typos in the files: wrong headers, missed commas etc? How to create a test case, which will confirm that the system can catch wrong inputs?&lt;/P&gt;
&lt;P&gt;Default unit testing in Talend can only allow comparing an output of the job (&lt;A href="https://help.talend.com/reader/Z6nEoVnqAU2j~MFxYHYeOg/Vjz9SwNFz0TcEIkvQeNX2Q" target="_blank" rel="nofollow noopener noreferrer"&gt;https://help.talend.com/reader/Z6nEoVnqAU2j~MFxYHYeOg/Vjz9SwNFz0TcEIkvQeNX2Q&lt;/A&gt;), but we have the error&amp;nbsp;message as the desired output, where can I find the design for this kind of test?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 06:51:01 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T06:51:01Z</dc:date>
    <item>
      <title>Talend Testing (error catch)</title>
      <link>https://community.qlik.com/t5/Data-Quality/Talend-Testing-error-catch/m-p/2268605#M2379</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;We are using Talend for data processing. At the moment we are at the stage of reading input csv files.&lt;/P&gt;
&lt;P&gt;We need to check the design for data quality: does the system capable of identifying typos in the files: wrong headers, missed commas etc? How to create a test case, which will confirm that the system can catch wrong inputs?&lt;/P&gt;
&lt;P&gt;Default unit testing in Talend can only allow comparing an output of the job (&lt;A href="https://help.talend.com/reader/Z6nEoVnqAU2j~MFxYHYeOg/Vjz9SwNFz0TcEIkvQeNX2Q" target="_blank" rel="nofollow noopener noreferrer"&gt;https://help.talend.com/reader/Z6nEoVnqAU2j~MFxYHYeOg/Vjz9SwNFz0TcEIkvQeNX2Q&lt;/A&gt;), but we have the error&amp;nbsp;message as the desired output, where can I find the design for this kind of test?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thank you!&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 06:51:01 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Data-Quality/Talend-Testing-error-catch/m-p/2268605#M2379</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T06:51:01Z</dc:date>
    </item>
    <item>
      <title>Re: Talend Testing (error catch)</title>
      <link>https://community.qlik.com/t5/Data-Quality/Talend-Testing-error-catch/m-p/2268606#M2380</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #3e3e3e; font-family: 'PT Sans','Helvetica',Helvetica,Arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 27.42px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;"&gt;Actually the test case only need a tAssert with a condition on it, which&amp;nbsp;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #444444; font-family: 'source sans pro',sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;fetches the execution status information from repository, Job execution and &lt;/SPAN&gt;&lt;SPAN class="keyword" style="background-color: transparent; box-sizing: border-box; color: #444444; font-family: &amp;amp;quot; source sans pro&amp;amp;quot;,sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-tap-highlight-color: transparent; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt;tAssert&lt;/SPAN&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #444444; font-family: 'source sans pro',sans-serif; font-size: 15.33px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;"&gt; based on its pre-defined schema&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;BR style="background-color: transparent; box-sizing: border-box; color: #3e3e3e; font-family: &amp;amp;quot; pt sans&amp;amp;quot;,&amp;amp;quot;helvetica&amp;amp;quot;,helvetica,arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;" /&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #3e3e3e; font-family: 'PT Sans','Helvetica',Helvetica,Arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 27.42px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;"&gt;As long as you can catch the error, and set a variable to false.. you should be able to set the value in the tAssert later.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #3e3e3e; font-family: 'PT Sans','Helvetica',Helvetica,Arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 27.42px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;"&gt;Let us know if it is what you are looking for.&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #3e3e3e; font-family: 'PT Sans','Helvetica',Helvetica,Arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 27.42px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;"&gt;Best regards&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="display: inline !important; float: none; background-color: transparent; color: #3e3e3e; font-family: 'PT Sans','Helvetica',Helvetica,Arial,sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 27.42px; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; word-wrap: break-word;"&gt;Sabrina&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 23 Jan 2019 08:23:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Data-Quality/Talend-Testing-error-catch/m-p/2268606#M2380</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2019-01-23T08:23:41Z</dc:date>
    </item>
  </channel>
</rss>

