DSXchange

Thanks Ray. I gave a wrong example for my question actually I want to paste the following warning. seq_Surv: When checking operator: When binding input interface field "HouseNo" to field "HouseNo": Implicit conversion from source type "ustring[max=10]" to result type &q...

Hi All, I am getting the following warning message in most of the jobs... I tried TYPE CONVERSION 'USTRINGTOSTRING' in Transformer to eliminate few of the warnings. I have so many jobs which has the same warning, can anyone suggest me best approach to clear the warning. WARNING: ds_AddressFreq: When...

Thanks Stuart for the help. I checked all my input columns in my match Specification, passes etc. They are same and I provisioned my Match spec and ran the frequencies still there are discrepancies in the job and the error persists. I haven't tried the configure specification yet, but I don't think ...

I have one more question to add... Is it necessary to have the input columns in the Frequency files? Because I encountered the following error: ref_MatchAddress,2: Frequency information of type C for reference input column FirstByteOfStreetName is not present in the reference frequency file ref_Matc...

Lately, I removed Copy Stage and replaced with Transformer at the beginning to split the data. This particular error is gone but I have a different error this time. Job got aborted with the following error: ref_MatchAddress: Unable to locate column FBOrStreetName in the input link with the following...

Hi, I Provisioned ALL the match specifications and rules sets before running. I tried pasting the image but I am not aware how to do so. In this job, I am splitting addresses(service and bill) using copy stage, later standardizing both and later used reference match to get the Match records and Resi...

Hi Experts, I am facing the following error when I am trying to compile a job which basically uses Qualitystage. Can anyone please throw some light on the following error: Mapping failed to copy attributes: Job Defn -> DSJobDef (Eobject:c2e76d84.43058877.3c55f2b1.a03e9fa0-8113-43d3.8347.d0eac3d04784...

Why were you using the DIGITS transform for that kind of data? Do you sometimes have something other than digits in there? It really was meant to do something like this: DIGITS("(303) 555-2201") = 3035552201 I don't see the need with the data you posted. Just set the data type appropriate...

I don't believe there is one. What does the data in your lnk.RECORD field look like? Something the StringToDecimal() function can't handle? ... Data in lnk.RECORD looks like 2147483649, 2146789564, 2145679845 etc.. Then we are using function DIGITS(lnk.RECOD+1) in parallel transformer. Do you think...

Hello All,

I have a DIGITS function is server job and when I am trying to replica the same to the parallel job the derivation is not getting validated in the Transformer.

Function: DIGITS(lnk.RECORD + 1)

May I know the equivalent DIGITS function for Prallel Job ?


Thanks

So, what is your database? When you say "number" do you mean an Oracle NUMBER field with no precision (rather than something like NUMBER(10) in other words) or something else? Who decided it was a uint64? And if your data types are correct, how were you planning on fitting everying from t...

I was wondering what a "unit64" data type was. :wink: A "uint" is an "unsigned integer" and the warning is telling you that there is a high probability that your unsigned 64bit integer source data won't all fit in your signed 8bit target integer field. You sure you hav...

Hi Experts, When I am running the job I am getting the following error (Warning): Warning: "When binding output interface field "TDCID" to field "TDCID": Implicit conversion from source type "uint64" to result type "int8": Possible range limitation."...

@Sainath -- Yes, when we have V 7.5 server jobs were developed after we upgraded to 8.1 we imported 7.5 jobs into 8.1 and started using few of them for the new design. So, in a sequencer there are mix of server and parallel jobs.

Hello Experts,

I have parallel jobs and server jobs called in a same sequencer in different Job Activities. Will there be any performance issues ?

Parallel jobs are developed in v 8.1
Server Jobs are developed in v 7.5

Thanks