DSXchange

Thanks Craig - works great!

In a sample set of data, the format of my input file appears as follows: CUST ID, HOME_PHONE, BUS_PHONE, ALT_PHONE I'd like to normalize the data so that the output appears as follows: CUST_ID, PHONE_NUM, PHONE_TYPE The PHONE_TYPE column would reflect whether the value in PHONE_NUM was sourced from ...

I realize that similar questions have been posted about the Pivot stage, but the situation I'm looking at is slightly unique... We have an inbound file with over 50 occurrences of a particular field. We would like to normalize this data into separate rows, and it would seem that the Pivot stage is t...

I realize that "Windows vs. Unix" is a perennial topic in this forum, but I'll try to narrow my questioning down a bit... Has anyone migrated from the enterprise version of DS in a Unix environment to the comparable DS version in a Windows environment? What were your observations in terms ...

Thanks folks...

In the end, I cheated by switching over to the parallel canvas and defining my sequential file delimiter as "none". Seemed to work ok.

I'm almost embarrassed to ask this question, since it seems so simple, but here goes... I'm attempting to read the entire contents of a row from a sequential stage into a single column. The rows within the source file have varying lengths and may contain any ASCII value. I've defined a single column...

Hi Folks,

If I've customized auto-purge settings for a particular job, can I automatically promote these settings when I promote my code to production? (I tried simply exporting, then importing, my job. Didn't seem to work, though.)

Thanks,

Peter

Thanks Craig. Would we need to delete the D_ file as well as the directory, or just the directory?

Hi Folks, One of our jobs failed in production last night, and the director log mentions that an abort was raised in a hashed file stage. In Windows, the directory specific to the hashed file in question contains over 500K objects, each of which seems related to a specific record. I've never seen th...

Thanks for the suggestion!

I'm receiving data in a db2 extract where the time is represented by an integer based on the number of milliseconds that have elapsed since midnight. I'd like to convert this to a standard time format (i.e. HH:MM:SS.TTT). I realize that I can write my own routine to do this, but I'm hoping that ther...

No appending is occurring. The problem is not that there are additional objects or jobs within the export. Instead, additional attributes are found within the subrecords of the objects.

The differences appear to relate to additional attributes appearing within the data. For example, one subrecord that applies to an element of a transformer has 26 associated attributes defined in the development dsx, but 54 in the production dsx.

I've taken a dsx export of a category from our development server. Later, the admin promoted this same category to production and created a dsx export of the category from the production server. Oddly, the two dsx files are significantly out of sync. Attributes that appear in the production dsx expo...

The pathname soecified by the APT_CONFIG_FILE environment variable, wherever it is set, will be used to specify the configuration file with which a parallel job is run. So...am I correct in understanding that the $APT_CONFIG_FILE value set up as the project default will be used by a job even when t...