Informatica router transformation-Issue
I am facing a weird problem with router transformation in Informatica. I am using it in my mapping where I check for a particular port's value and based on the condition, I route it to appropriate flow. While I debug, I see the value of the variable as expected, but the row is identified as "filtered" in the debugger. I have tried various other methods like trimming the variable (LTRIM/RTRIM) to ensure there is no trailing spaces which makes the router condition fail, but that doesn't work either. As a result, my rows which are supposed to be inserted into the target as bypassed. Have anyone faced similar issue? I am wondering if I am missing something here.