DSXchange

After triming the data, you need to COUNT the number of delimiter. If you have 4, you need to follow the given example.
First two field will be the state. Else go with 1,2,3 as three different fields.

Hope you dont get any issues agian. Thanks for sharing the solution.

Thats good vivek. The solution will be useful for further searchers well. Would you mind marking the thread as resolved, so that it will more useful to locate easily.

So no other go, you need to check whats after 14M records. Try to split the file by some means for testing purpose to know what went wrong. Run the second half and see if your machine react the same way.

Partitioning in single node is same as running in sequential mode. Why can't you give a try running the job in Sequential mode.

Datastage find it best for immediate downstream operator, but as noted, it may not be best configuration for the whole picture.

Yeah, you can try to test if it works with hard codes stuff, but for daily run, you need to figure out why parameter value is not getting passes correctly.

Perhaps, first you need to install the client software.

chulett wrote:Yah, it's called a Filter.

By this time readers will know, who is wild and crazy.

chulett wrote:Or sort the data then use stage variables... there's a number of different ways. However, the answer to the question as asked is 'no'.

It sounds familiar.

You can find the button on the top of this post. If at all you are looking for one.

Better call it in separate job or routine.

So you need to create many users and assign the roles accordingly.

Hi Purushotham,
The variable should be included in your job for the effect to take place. Else the option what ever you specified in Index Mode will be used.

Ah... atlast I could see Kim online.