DSXchange

Why and What do you want to achieve ?

What is the datatype?

It worked for me in ASCII

Count the total occurance and take one less using index.

Count the total occurance and take one less using index.

How did you find it is the 'delete' stage that takes time?

How many rows matching the delete criteria are available in the target?

What if you do a delete outside DS? How long does it take?

Did you set commit intervals and see the count go down?

Did you get the plan for delete SQL?

Check for locks in oracle. Try running on single node config.

CFF stage picks only the record IDs you defne. So if you skip those you do not wish to extract, it will automatically drop it during import.

You can use the filter to pick only the record types you need and ignore the rest.

You can use the filter to pick only the record types you need and ignore the rest.

Convert is used to Replaces every instance of specified characters in a string with substitute characters.

interpret as

Convert is used to Replaces every instance of '/' in a string with 'newline' characters.

Manually think through the function and expected outcome

There can be several things.

What did you change in dsenv?

Search can be found right below the banner.

Parallel routines are to be used within jobs.

Guessing....

Do you have NLS enabled ?

Convert '/' to newline.

Search for "urgent" and see response from Ray.