DSXchange

Not in the SQL query, but you could certainly use this file in a Join stage.

If you create the hashed file in a directory you will need to create an entry in the VOC file using the SETFILE command.

It can even be Microsoft SQL Server.

U isn't trying to solve this; bharatmajeti is. The second person personal pronoun in English is spelled "you", not "u".

Check permissions.

The third character of "MC0X" is a zero, not an upper case letter "o".

You have a corrupted hashed file, caused (apparently) by taking its size over 2GB with only 32 bit pointers.

To fix, you need to convert the hashed file to 64-bit addressing.

No idea. Maybe if you showed us the script itself?

prakashdasika wrote:Use the transformer stage and stage variables with the help of substring function to do it.

Why substring function?

As U observed, the documentation is curiously silent on whether selecting this check box disables local repository logging (to RT_LOGnnn tables).

If you have version 8.5 the PXPivot stage can perform vertical pivot.

Why not simply a Lookup stage followed by a Transfomer stage to convert null to "N" and anything else to "Y"?

No parallel function is available out of the box. You can use a BASIC Transformer stage to invoke the Oconv() function with "MC0X" as its second argument.

"ROSS" could very well be 12 bytes.

Why not use SCD stage?