DSXchange

Hi, I have a requirement to generate a | delimited file. The final delimter of the record also should be |. I specified the First line is column header to true. I set the record level final delimiter to |. I set the Field level delimiter to |. I am getting everything properly except the final delim...

Hi, I designed a job sequence (call it Mainseq1) to run two other job sequences (call them Subseq1, Subseq2) in parallel. MainSeq1: ------------ UserVarAct1--->Subseq1JobAct UserVarAct2--->Subseq2JobAct Although Mainseq1 is starting Subseq1, Subseq2 in parallel, actually Subseq2 is waiting for Subs...

Hi, I'm converting a server job into parallel. In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence . should i create a output routine There ...

Refer to Page 2-27 of "Parallel Job Developer's Guide". DataStage is flexible about meta data. You can define part of your schema and specify that, if your job encounters extra columns that are not defined in the meta data when it actually runs, it will adopt these extra columns and propag...

How is this job called, from a controlling prospective? The controlling job, whether it be a shell script or a job sequence, you can do this while passing the parameter to this job. In a shell you can use the commands like date and pass month mask for one and year mask for another. In a sequence jo...

Hi All, Is there any point in keeping Lookup Failure to Continue if Lookup Condition has been set to Fail. The latter condition will always abort the job if the lookup fails.Please enlighten me. Thanks in advance. How can you set the Lookup Stage to Fail and Continue at the same time? So fail and c...

Hi, I designed a job sequence (call it Mainseq1) to run two other job sequences (call them Subseq1, Subseq2) in parallel. MainSeq1: ------------ UserVarAct1--->Subseq1JobAct UserVarAct2--->Subseq2JobAct Although Mainseq1 is starting Subseq1, Subseq2 in parallel, actually Subseq2 is waiting for Subse...

Ernie, Kenneth, Thanks for the response. One thing I didn't make clear is that the record format of each of these files could be different which rules out the concatenation otpion. We already have 17 types of files and expecting to add more. Based on the file name, the job sequence determines which ...

Hi, We have a requirement where we need to process data files received from external vendors real-time as soon as they arrive. Till now we are batch loading these files at pre-scheduled times using AutoSys scheduling tool. Couple of options we are considering are: Option 1: ---------- Use Autosys fi...

I am the OP. Sorry for the delayed reply as I was away. My input is a sequential file. As "Vincent" mentioned I am importing the data as string type and implicitly converting in the Transformer. I had to do this for other reasons. Vincent you mentioned "you can import it as string fie...

[quote="I_Server_Whale"]You can use [i]Num, Alpha, AlNum,[/i]etc functions in your constraint.[/quote]

Thanks for the response. You mean check the data type of each column? What if I have 100 columns in the input link.

Hi, I am designing a parallel job. In parallel jobs typically if the incoming column data type is invalid (for example string data for a numeric type column) the job warns "Numeric string expected of the appropriate decimal precision for input column 'xxx'. Use default value" and substitue...

I had similar issue with floats when using Sybase Enterprise stage. I tried several things that didn't help. Finally it worked when I used Basic Transormer and Sybase OC stage instead of PX Transformer, Sybase Enterprise stage with float defined as decimal in the column metadata. Eventually we ended...

is this a dos file that you are ftping over to the unix and then trying to load it? At the unix level, try the command dos2unix filename and then see if it fixes the file Thease are files ftped from a Unix server. The job worked with the same files before. We installed a patch for Oracle Enterprise...

After multiple tests this is what I noticed: The sequential file stage reads the first file successfully. From second file onwards the warning below repeats after every 830 rows. Please note that I am using "File Pattern" read method so I can load multipl files: Warning: SeqReutersPricingF...