DSXchange

chulett wrote:It's in the linked posts, but to bring it here:

Code: Select all

stage_label.$JobStatus = DSJS.RUNOK Or stage_label.$JobStatus = DSJS.RUNWARN

stage_label meaning the name of the Job Activity stage to check.

I missed it, I apologize. Thank you!

I have the same question. I looked over the post that was linked, but I either do not fully understand or I am having trouble translating into a single Job Sequence, rather than a sequence of sequences. My Job Sequence is 3 jobs executed in serial, each of the subsequent jobs can run on an "Exe...

I use Field quite often. I have source data that looks like this part1@part2@part3 I use a Transformer to split the one column into three: Field(in.col1,"@",1) Field(in.col1,"@",2) Field(in.col1,"@",3) And the Transformer does about 5 other conversion and adds in two ad...

I have had a similar delimiter problem when I failed to check my input CSV that I received from a coworker. About halfway through the file, the comma that should have separated the 3rd column from the 4th column (4th being nullable and last column) disappeared. a,b,c,d <- ok e,f,g, <- ok ... w,x,y <...

Hi, As far as I know Trim function works for Varchar data type. You cannot use Trim for fields which are of Char data type. Please correct me if I am wrong. I am not sure, but I will say that I was experiencing a challenge with a Lookup Stage as my input was Char and lookup reference was VarChar. O...

Do an order by and max(timestamp) in the Ora and the result of that, will be your lookup. This way you will have only one row per name. Thanks! I worked through the full sql with a couple of DBAs and it works! Search for "surrogate key" and "type 2 slowly changing dimension". Gr...

We do a very similar collection for our Capacity Planning/Demand Management for DataStage servers: osh OshExecuter\\.sh uvsh.* Then we tie each of those to the Username associated with the Project. Owner + Process = Project. That way we can track the resource consumption of a project. Which is what ...

I have been working through many issues with my most recent lookup stage, and now that they are resolved, I have hit a new challenge. Dimension A has two columns I care about (name, ID#) and several attributes (the rest of the columns). For historical reasons, I would like to keep the old attributes...

I just updated all 11 Timestamp Transforms to be: StringToTimestamp(inlink.columnName: " 00:00:00") And all of the errors and warnings went away. The Timestamp warnings, the Julian Date errors, all gone. Data loaded into Oracle successfully. I am so very confused. Again, thanks to all who ...

Let me see if I can clarify and answer the above three questions. And again, thanks! You don't have any kind of Julian date. Why is that particular error being reported? The Timestamp Warning applies to 11 of the 48 fields I am converting to Timestamps. There are also about 10 Julian Date fields, de...

How are you pulling the data? Is it already in timestamp format? Are you pulling directly from ORACLE? Analyze its select sql, does it have TO_CHAR() for the date. If yes then you are getting a string and StringToTimestamp() should work. Post that error code here. Also, what is your incoming date f...

What is the length of your target stage? What is your target stage? If its not a flat file then try writing to a flat file. I have done this in the past with success. Thanks! I like the sig, btw. Target stage is Oracle, a different table than the source. According to the table defintion, type is ti...

Hello all! I am attempting to use a Transform stage to convert incoming date as VarChar(100) from one Oracle table to Timestamp(38 ) in another Oracle table. For example, in_external_Date_Dim.GREG_D = 2006-01-01 I have attempted variations on StringToTimestamp( trim(in_external_Date_Dim.GREG_D) : &q...