https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331372#M100358 Hi,<BR />Could you please post your job setting screenshot into forum which will be helpful for us to understand your current situation?<BR />Best regards<BR />Sabrina Wed, 31 Aug 2016 09:51:54 GMT Anonymous 2016-08-31T09:51:54Z https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331371#M100357 <P>I have a case where I am comparing BigDecimal values from SQL and Redshift. Even though the values are the same, "If" condition is not working and is displaying it as 'false'. Is there any "CAST" operation that is recommended in the 'tmap' component to compare BigDecimal/Decimal values from 2 different database systems.</P> Tue, 30 Aug 2016 23:41:23 GMT https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331371#M100357 Anonymous 2016-08-30T23:41:23Z https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331372#M100358 Hi,<BR />Could you please post your job setting screenshot into forum which will be helpful for us to understand your current situation?<BR />Best regards<BR />Sabrina Wed, 31 Aug 2016 09:51:54 GMT https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331372#M100358 Anonymous 2016-08-31T09:51:54Z https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331373#M100359 We had a Talend training session in which the instructor recommended to output the values into text file and then compare the values. Wed, 07 Sep 2016 00:46:38 GMT https://community.qlik.com/t5/Talend-Studio/Compare-BigDecimal-values-from-SQL-and-Redshift/m-p/2331373#M100359 Anonymous 2016-09-07T00:46:38Z