DSXchange

You may need to adapt the IsValid() function (for server) because it is a little more forgiving of date format. Note also that Iconv() does not return NULL unless the date is actually NULL. You would do better to check the result of the Status() function after applying the Iconv() function. Did you ...

I am not seeing this behaviour in version 8.0.1 (on Windows).

Aggregator stage for the aggregations. Transformer stage for the difference. (You can also do the aggregations in stage variables in a Transformer stage if the input data are sorted by the grouping column.)

Investigate use of the Compare or Difference stage types, and differently named columns on their inputs. By this means you can capture the "deleted" records. You can not do so with the Change Capture stage because, as you observe, it only outputs the "After" data set changes. Thi...

Probably DateFromDaysSince() would be more appropriate.

This is more easily done with a BASIC Transformer stage and server routine (or a server job would be even better for so few rows). Use that to populate a file, keyed by row number, which you can then look up in your parallel job. The routine would keep a dynamic array of values already generated, an...

Field #7 (if I remember correctly) contains the invocation ID. You can constrain your query/selection on this.

What operating system group is associated with the DataStage Engine folder (a sub-folder within X:\Ascential\DataStage), and to which group(s) does testuser belong?

chandra4u wrote:Any other suggestions !!!

I find that offensive.

There is not a single "UTF-8" encoding. Unicode Transformation Format (8-bit) is implemented differently in different places. See Unicode Consortium website for more information. How was the source file created? Are you sure it wasn't one of the Korean-specific character maps? Have you tri...

Hi, i see on the forum that you have anwser to a similar problem that i have today, actually we can't created new projects, it return the fowlling message DSR.ADMIN: Error creating a schema Some users will not have access to this schema. how do you resolve this problem ? There is an anwser in the f...

Hi Ray, I am getting below error while processing the 55 lakhs records for fact table.. i am sorting the data by using sort stage ,after that am aggregating the data by using aggregator stage. buffer(0),1: APT_BufferOperator: Add block to queue failed.This means that your buffer filesystems all ran...

Assignment of value is not possible with Modify stage. Any Modify stage function requires an input field reference.

You can use Column Generator stage to generate as many columns as you desire, not just one. You can also use Transformer stage.