DSXchange

Hi I have searched for "delayed metadata" on the forum and the closest one is this one ( http://www.dsxchange.com/viewtopic.php?t=114754&highlight=delayed+metadata ), but I am not loading data to Teradata but reading from Teradata using the TeradataPX stage. The SQL uses a derived tabl...

Hi Been a long time user of DSXchange and looking forward to a few more years :) Thanks for creating those tutorial DVD's, they have been pretty useful coming from server edition to PX, although one or two of the recordings were a bit on the bad side (voice recording). Have there been discussions ar...

Hi Arnd Thanks for getting back to me. I have unspecified the fixed width property and replaced it with record delimiter (unix newline), the metadata for the column specifies the width of the record. I now output to a peek stage and rejected records are displayed in the log. It works on all except o...

Hi All I've been reading around and finally figured out how to set up the reject link from a sequential file. My job has a sequenctial file outputting to a transformer and a 2nd sequential file as the reject link. The source file is 1348 bytes wide (fixed width) and I'd like any records not of the s...

Hi xchangers! Thought I'd share the following with you. I'm pretty sure it hasn't already been raised in the forum. From the source file I strip out the columns I want using start and end lengths of the record (source = fixed length file). This I output to a transformer as varchar fields (all). An e...

Hi Guys I have joined a project and have found we have plenty projects on one server - a good server - running solaris 9 with plenty CPU and memory available. Attempting to log in this morning I find datastage VERY slow in returning job list. I ran SAR: 09:38:11 %usr %sys %wio %idle 09:38:16 1 66 4 ...

Hi Guys I have a series of files that can be processed using 1 job that accepts parameters - i.e. a multiple instance job. Does it make a difference to performance if i have 1 multiple instance job that is invoked many times or is it better to have multiple jobs that are copies of each other? I susp...