DSXchange

rstemphowski You should set the User Status inside the job ( Is the same for server and parallel jobs). You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job Each time the job is execute the User Status value will be ref...

rstemphowski You should set the User Status inside the job ( Is the same for server and parallel jobs). You can interrogate the value of the User Status in any point - downstream - in the sequence after the job activity that call the job Each time the job is execute the User Status value will be ref...

Ascen, What I mean is that because you can't generate frequency data in a real time job, then: 1) Standardized and generate frequency for you reference data in a separate job - no a real time one. Execute this job as part of a weekly batch (Really depend on how frequently your reference data change)...

Hi,

Start --> Programs --> Information Server --> Documentation

The IBM Red book "IBM InfoSphere DataStage Data Flow and Job Design" explain this in detail

Hi, Match Frequency stage is not a real time stage - also it will be time consuming - so you would like to generate the frequency data set in a separate job that can be execute as frequently as your reference data change To fulfill the requirement of the match stage to have two frequency data set - ...

suneelchallagali, All records having nulls values in blocking fields are skipped in the current pass, but become available for other passes. Just add other passes with different blocking fields to process those records Records will become matches, duplicates or residual depending on the composite we...

sreenathprakaash...

Look like you won't have a Current Indicator fields so you should define your eff_dt column with a purpose code "Effective date (Type 2)" in the Input --> Lookup page of the SCD stage


Hope this will help

Thanks,


Julio

suneelchallagali, Just to be clear, you need exact matches on ssn and birthdate and matches were if the ssn or birthday are missing or are different then you would like to get all records that match 90% base on First_name, Middle_name and Last_name? If so you should have two passes. One having only ...

suneelchallagali If you are looking to get only exact match on birthdate and ssn then do not use any matching fields the process will dump into residual all records that don't match on those two fields Regarding the error looks like the processes - players on different node- are running out of resou...

For QS you should have another database - The Match Designer database - that could be hosted in DB2, Oracle or SQl Server

Julio Rodriguez

suneelchallagali If you are using SSN as a blocking variable you don't need to include it as a matching variable. The process will compare only records with same SSN anyway Having a cut off as 0 doesn't mean that records having a composite weight greater than 0 are matches. You should play around wi...

Srinivas,

I was having same error and it was related to C++ compiler not properly set up

Try to compile any other job having a transformer stage ...


Hope that this help

Julio

aasaif: While converting the date value from internal to external using Oconv function, the mask in the Oconv function is specifying to spell out the month piece - A3 - but you are expecting digits OCONV(ICONV(Field(DSLink2.CreateDate," ",1,1),"D"),"D-DMY[2, A3 ,2] ") A...

Hello Tacitus:

We are having same issue with Avaya - CMS- database. We tried port 3077 but it didn't work for us.

How you find out which is the port for Avaya (CMS) database?

Thanks,

Julio R.

Welcome to CASS! Delivered Point Verification(DPV) are just values that help you identified if an address is currently represented in the USPS delivery point file(reference file) as a valid delivery. Also with those columns you should have a better idea if the address is a false positive or what kin...