DSXchange

We are using DataStage 7.5.1 on AIX and DataStage TX 8.0. We deployed a compiled TX map to the DataStage AIX server and tried to use it in an EE ETL job. After many problems, we were at least able to get the map into the proper area of the General tab. The problem we kept running into was the client...

I'm reading input information delimitted by "^" but there is a variable number of fields in each input line. I can use the DCOUNT function to tell me the number but I'm stuck on how to get the information split out into the separate fields with the field function. Is there a way to set up ...

Thank you both for the help; I had played with TimestampFromSecondsSince but was not using it in the correct way. I've now got it working.

I need to subtract one second from the current time in a parallel job; does anyone have an approach or an example?

much appreciated

Thanks Kenneth, lots of good points. It would be great to hear from others. I've been leaning towards an approach like the below for some time: - process common lookups used in multiple places into a lookup dataset once - for dimensions with very few records (under 10,000), process and load in one j...

I'm curious of what others use for a "rule of thumb". For instance, we have lots of ETL that sources less than 100,000 records (expected to maybe reach 700,000 at some point). If there are 10 lookups and simple transformations, would you have a job to create lookup datasets, another to do ...