DSXchange

What are the NLS character map and locale settings for your job? Check (using the Administrator client) that these are actually loaded. The error message suggests that one (at least) is not loaded. If you find that this is so, use the Administrator client to load it. You will have to re-start the D...

It appears that you are using DataStage with NLS enabled, but have not specified a character map for the Aggregator stage (NLS tab on stage properties). However, this should default to the map defined for the job. The other possibility is that you have a different number of columns on the output li...

It appears that you are successfully generating what you want, but writing it for every input row rather than just for the final row. There are a few ways to achieve your desired result; probably the easiest is to run your (single column) output into an Aggregator stage grouping on "Last"...

It appears that you are successfully generating what you want, but writing it for every input row rather than just for the final row. There are a few ways to achieve your desired result; probably the easiest is to run your (single column) output into an Aggregator stage grouping on "Last"...

I have a reference table on Oracle with two columns: values defined in column A should be converted to values defined in column B. Through my transformer, I need to accumulate this data into one sequential file in the following format: A=B|A1=B1|A2=B2| and so on. I am expecting to receive one row of...

Thank you all for help and suggestions. I agree with Craig, Buying another software might save some development time but will cost some money which my company is not ready to spare at this time. I did find the way of using StringDecode function. It was our error thinking that we need to load argumen...

In order to standardize the customer names and addresses, I like to create a function (or use existing ones) that replace occurrences of words. For example: Customer Name: "XYZ COMPANY" change to: "XYZ CO" Address: "201 RAMPART PLACE" change to "201 RAMPART PL"...