DSXchange

The same way as advised to kailas.

The UNIX sync command forces any pages in memory that have not yet been written to disk to be written to disk. This is important for DataStage engine, which makes extensive use of shared memory. The second sync command picks up any pages that might have been modified while the first sync command was...

The Transformer stage does not - CAN not - change the order of the rows it receives.

Or perhaps to differing volumes of data. Are you using read or write cache with the hashed files? Try disabling cache and see whether the differences disappear (you can re-enable later).

Try "the Microsoft solution" - reboot your client machine.

Then why did you mark the job type as "server"?

Always execute sync twice prior to stopping DataStage.

No.

Are you asking U specifically? U does not post here all that often. The second person personal pronoun in English is spelled "you", not "u". Please preserve a professional standard of written English on DSXchange, not least to help those whose first language is not English. Have ...

Use a Convert() function to replace any non-alphanumeric character with "".

Tip: create a stage variable and initialize it to a list of the non-alphanumeric characters. Use that as the first argument of Convert() function.

Even though it's red, have you tried compiling?

Have you considered an External Filter stage that uses something like sed or awk commands/scripts?

No, provided that you have a server that can deliver infinite supply of CPU, memory, disk space, disk I/O bandwidth and network bandwidth resources.

Please mark this thread as Resolved using the green button at the top.