DSXchange

Staging data to sequential files from a parallel job is very inefficient as it needs to unpartition the data back into a sequential stream to write to the file and repartition it across nodes in the second job. If you feed a sequential file directly to an aggregation stage without any sorting option...

You have some type of transformer syntax error. Reset your job and see if an extra message appears in you Director log. Sometimes you get a message about an error that is retrieved from the previous run. Also look in the '&PH&' directory under your project folder, sort the files in there on ...

Ask Ascential sales to send you the PDF of the SAP Pack. It's got a few screen shots in it that shows you how SAP data is exposed to a DataStage job.

The Oracle change data capture component from Ascential does log scraping against the Oracle database engine to grab changes. You can also do change data capture within jobs using the CRC32 function. There is a download demo available from Ascential devnet. We have two layers of CDC. We take delta d...

Parts of version control have been superceded in recent releases. One of the main benefits used to be the ability to deliver jobs as readonly to test and production environments. Now there is the "Protected Project" option that does this through a single check box. There is the ability to open older...

Can't help you on that one. Strange that you would get an error and still have all rows processed. Have you mounted the /apps/Ascential and /projects directories to the remote DB2 box? The DataStageEE Remote DB2 Configuration doc states: Either NFS mount both the /apps/Ascential and /projects to the...

I have a date field coming in from DB2 in the format DD-MM-YYYY. I want to use it in a date function that needs it in the format YYYY-MM-DD. What's the easiest way to do the switch? Can do it in a modify stage or a transformer. Needs to handle one or two digit days and months.

Looks like a permission problem on the pivotenu.so file. On my system this file is owned by dsadm user and the dstage group and has permissions of -r-xr-xr-x. This means anyone can execute it. It can be found in the $DSEngine/lib folder.

Try exporting it as XML using a XLS stylesheet and then viewing the export file in a web browser. You should be able to find the column names in a HTML table format that can be copied and pasted straight into Excel. There are a couple XLS stylesheets in the DataStage directory for formatting output ...

This is a long overdue sale, Evoke software who make the Axio profiling tool have been bought by Similarity Systems. I've never heard of Similarity but they make data quality software called ATHANOR. (Wasn't he a Middle Earth elf?) They expanded into the US in February of this year. Evoke Axio is on...

Can you flip your job around, make the lookup your source and make the primary stream your lookup.

I could be barking up the wrong river without a pole but it could be that DataStage is combining your DB2 and transformer operators into one process. To quote the manual "Under the covers DataStage can combine the operators that underlie parallel stages so that they run in the same process.". To avo...

There are 50+ training sessions on offer, either during or after the conference (session details are not available yet). There are also plenty of opportunities to use the Hawk and Serrano software in the partner pavilion. No mention anywhere about certification.

You might be able to modify multiple records on the target table for each input record by writing a custom update SQL where you set the target field to a aggregation of the input field and the target field. Eg. UPDATE MYTABLE SET FIELDA = FIELDA + :1 WHERE FIELDB = :2

The tool comes with good help files and a PDF. I'd advise you to create two play projects, one for dev and one for prod, and perform a few test deliveries of jobs between the two. Try out the different version numbering and documentation options. Make sure stuff delivered to prod stays readonly. Put...