DSXchange

Cant we use all the coditions in filter stage as we use in Where clause of Oracle query. When i try to use the Upper(xxx), Parse error. Does it work only for like and between. does it work for =, AND, OR etc

It's not Oracle. Crazy thought, but try reading the documentation for the stage. It is documented in the Parallel Job Developer's Guide, which lists all "Supported Boolean Expressions and Operators" for it.