I am trying to extract data from greenplum database and loading the data to a oracle database by using tMap.
though the data is being moved from source to tMap but not being loaded to target table.
The job is being successful but 0 rows are being loaded to target table.
i have attached the screen shots below.
Can anyone suggest me what can be the issue.
Review the filter defined for copyOfOutput6.
What do you expect with it?
If you want to filter input rows, use the filter on the input flow (activate expression filter for row2 in the tMap).
Thanks for reply.
By that expression i want to filter out the rows in which the part_number is null.
except those rows rest all the data need to be loaded in target table.
i have tried that also.
but its showing error that string cannot be converted to Boolean.
this is the only expression where i am not getting any error.
but i think this expression is to pass the data who has null value in part_number.
that is why no data is being loaded.
but i want to pass the data who don't have null value.
can you please suggest what can be the expression ?
I have tried both the expression you have suggested.
still same problem, though the data is being passed from source to tMap but unable to get loaded in Target table.
I have tried using tFilter as well.
the data being passed from filter being filtered to the tMap, but no data being loaded to Target as before.