DSXchange

Hello all, I am facing a strange problem. I can log into Designer and open any parallel job that I have previously developed. However, when I try to compile any of these jobs, the Designer hangs and freezes. I talked to my admin and he is getting the same result. The only thing he see in the error l...

Ray, You are correct. The reason I was getting double matches was because the Otherwise link was second in order of execution. I moved the Otherwise link to last (by simply detaching and re-attaching the link to the transformer) and it ran with correct number of outputs. I guess it never hit me that...

Ray,

It is not the first, but it is the second condition when I open the constraints window. I am not sure how to move the order of constraints around, but I will figure it out and put the Otherwise last and see if that works.

Thanks.

Thanks Ray.

However, there are records that are meeting my criteria. If you re-read above, there are 68 records that get passed to by C4 constraint. Also, all 1000 records get passed to the Otherwise link. So it seems that some records are going down two output links.

Hello all, It seems my constraints on my transformer are not working correctly (or the way I think it should work). Say for my input, I have 1000 records. I have five output links from my transformer. Below are the four constraints. The other output link is the Otherwise. C1 = Len(Ln_ds_src.SBB) <> ...

Thanks for the reply.

Not sure what your exact response was, since I am not a premium member. However, I believe to understand that we cannot use assignment statements within stage variables.

I will try and see if there is a workaround.

Hi all, I am trying to increase a counter based on a record match. I first initialize the counter to 1. If there is a record match, I want to increase the counter by 1 else set the counter to 1. For instance, if there are five records matches in a row, the counter would be equal to 5. Below is my co...

MOD works perfect. Thanks guys.

Hello,

I have a requirement to check if a column is a multiple of 100 or 1000. Is there a simple way of doing this?

Also, I am using Netezza, so if there is a Netezza function that does this, please let me know. I have searched but came up empty.

Thanks in advance.

Hello, I am trying to read a flat file using a schema file. I am able to read the first column correctly, but all other columns come back as NULL. The source file has no delimiters. What can be causing this? Below is my schema file: record {final_delim=end, delim=none, record_delim_string='\n', quot...

I got rid of these warnings when I defaulted the NULLs. Using something like below: If IsNull(COLUMN1) Then "999999" Else COLUMN1 the warnings disappeared. Not sure if this is a resolution or a workaround due to the fact that I did not know why this worked, but I will mark it as resolved f...

I set the OSH_PRINT_SCHEMAS environment variable, but it was not a help. The log showed the same as before. I am working in version 9.1. The stage that this column is being sourced from is a lookup file set. The column on that stage is Varchar(255) nullable. After the lookup, it is my transformer, w...

The input link does have "Precision" of 255 (assuming "Precision" equals length). The stage before Xfrm_1 has length of 255 as well.

Thanks for the reply Ray. Unfortunately, I am not a premium member so I cannot view your post. But I hopefully got the gist. Where is the "Precision" column you are referring to? I thought strings did not have "Precision" options. There is a "Scale" and "Extended&q...

Hello, I am getting the following warning below. My column defination for both my input and my output for this transformer is VarChar(255). Usually this warning means the input is unbound, but this is not the case. The metadata is a match (from what I can tell). Can someone shed some light on this? ...