DSXchange

For those particular combinations you are correct. It is not possible to assert that you are generally correct. Other words are similar in the right hand end, particularly names of corporate entities.

Open the Rules and open the Pattern Action Language file. It will be read-only, but that's OK for inspection.

Use a key-based partitioning algorithm when you need key adjacency in your design, for example when joining (including lookups and merge), grouping or removing duplicates. This ensures that the same value is on the same node for all rows containing that value and for all inputs. Keyless partitioning...

Open Director.
Disable auto-refresh.
Disable display of categories.
There's your list. Sort it how you will.
From the Project menu choose Print.
In the Print dialog, choose Print To File.
When done, re-enable display of categories and auto-refresh.

It's not VarChar(255) on the input link; it's VarChar with nothing in the Precision field. Therefore DataStage is alerting you to the fact that your design is mapping an unbounded string into a bounded string, which might lead to loss of data. To fix, make sure your metadata are correct and consiste...

Decimal always has a decimal placeholder. You can not remove it if the data type is decimal.

You can remove it if the data type is some kind of integer or string. There is another current thread on exactly this question.

Or, perhaps simpler:

The only limit on the length of a string in server jobs (and a sequence is a server job) is how much memory you have available to store it in. Certainly 50KiB won't be a problem.

Just a thought - can the password in config.ini be encrypted using encrypt.sh ?

Yes you can, but it's probably a waste of time. RVSNDX (and Soundex) will only look at 4-6 characters.

Then your data are being assessed as "most probably" GB addresses. Only inspection of the PAL will reveal why.

Have you specified GBR as the default country code?

dudam wrote: need to do Seq file itself dont use any other stag

Why?

It seems to me that this violates the "one task, one stage" philosophy for parallel jobs.

You could use a filter command in the Sequential File stage (such as tr for example) to eliminate the quote and space characters.

My company is seeking people with at least NV1 clearance and good skills in Information Management (particularly the Information Server suite) for work in Canberra. If you have both of these, please get in touch. Use links in my signature block.

The only Windows platform on which you can installed Information Server 8.7 is Windows Server 2008 R2.

This is documented in the Planning, Installation and Configuration guide.