Here is my requirement:
I have the below condition to be validated in my query transform.
not <table1>.Col1 in ('IZ','IT') AND <table1>.Col2 =' 3100011'
Instead of hard coding 'IZ,IT & 3100011 value used a Global variable and assigned the value to output value like below.
$Gv_output_value = '[$Gv_DCT_Value] and <table1>.Col2 = \' \' || [$Gv_MCU_Value]';
In the where clause in Query transform i used below.
not <table1>.Col1 in ('[$Gv_Output_Cardex_value]')
When i run the job, it fetched all the data and not properly taking the where clause coniditon. Not reallly sure where it is wrong and let me know your view.