Did you use the exact syntax like shown in your post?
COLUMN1 = X'0012345C'
I assume you are using a string port right?
Can you elaborate a little bit more on what you are trying to do and how?
Please share the error message which you are getting while validating the mapping.
0x or 0X is a prefix that is used to represent hexadecimal numeric values.
Here, as the datatype defined for COLUMN1 is string, ideally this how it should be checked:
Suppose if your source data does not have 0X prefix, you may simply use this condition:
Lekha G M
Yes I used same syntax in the filter transformation and it is a string port. I am trying to filter records using filter transformation and have to use hexadecimal representation of filter value in the filter condition.
While validating the expression it is throwing below error for filter condition COLUMN1 = X'0012345C'
<<PM Parse Error>> missing operator … COLUMN1=X<<<<'0012345C'.
There are not too many ways to specify hex values in PowerCenter.
Basically you can use CONVERT_BASE( '0012345C', 16, 10) to translate the hex string 0012345C into an integer number. Then you can compare this against whatever condition you need to check.