DSXchange

(
IsNull(lkp_CRC.CRC) or ( NullToEmpty(CRC) <> NullToEmpty (lkp_CRC.CRC) )
)

OR
(
IsNull(lkp_CRC1.CRC) or (NullToEmpty(CRC) <> NullToEmpty(lkp_CRC1.CRC) )

)

The limitation of stage variables, as other poster stated, will depend on your system resources ... and your initial list of string could be implemented using stage variables But unless you have a static source, more new strings will come soon after the code got into production environment, and for ...

This was intended to remove all job logs from the metadata repository due to a bug in version 8.1 At version 8.1 the jobs logs can be saved in the metadata repository or using the old way having them in files. But there is a bug - I did some post about it a while ago - and Big Blue recommended to re...

Sequences are the way to go ....

DvStand, The repeat action will allow you to read/treat more than one token of the same class in the input record. Pattern Action Reference Language, pag 55: "Performing actions repetitively". Just be careful to code and exit condition to avoid infinite loop Below code will remove all Q ty...

If the Address Standardization is working fine as stand alone then take a look at MDM MDM is highly parameterized application, ask the MDM guys to take a look if the address standardization process in MDM configuration is disable ( parameter QS_STAN_ADDRESS) or maybe MDM is expecting the original sh...

Check if:

- You have same hashed file name in both jobs
- The key definition is same in both jobs

I guess that the botleneck is not in the sequential file but in the oracle stage ...yoou can test this by replacing your Oracle stage with another sequential stage What's your commit strategy? Delete operation is database intensive and time consuming, mainly because it forces the database to generat...

If you are seeing the column from the Frecuencies data set you should just rearrenge the link order, this happen when the Link from the frequency data set is attached first because the tool assume that the first link is the data...... assuming that you have both links standardardized and Frequency i...

Which specif 8.x version? There a couple of setting for 8.0.1 where you need to set $DSHOME/dsenv ...

Please notice that MQ Stage <> MQ Connector ... looks like you are using the MQ connector. Please post your job design....

By default the tool will show results as expected by case No. 2 records. Because both cases contradict each other and to avoid changing the default behavior of the tool the approach should lean toward addressing the exception, case No.1, only I would treat those records after the standardization pro...

Maybe I should take my answer back and explain further ... If you are going to apply unhandled pattern overrides using the GUI you would like to treat one token at a time. As far as I know, the tool don't represent unhandled patterns using "?" class( Somebody can correct me if I'm wrong), ...

Well ... you would like to: M | + | Q | ? COPY [1] temp CONCAT " " temp CONCAT [2] temp COPY temp {Manzana} COPY [3] {ExceptionData} COPY_S [4] {Asentamiento} RETYPE [1] 0 RETYPE [2] 0 RETYPE [3] 0 RETYPE [4] 0 RETURN Only [4] using COPY_S to preserve the space in between, the rest of toke...

Is a bit different, what I mean is: - Add a subroutine to the action pattern file, probably at the end - In the subroutine add all your new pattern actions - Call the subroutine when in the current Pattern File they are determining the piece of data that will be mark as "unhandled" When a ...

It's difficult to say without having the pattern action file for your Rule Set and without any knowledge of Mexican Addresses. Normally UNHANDLED PATTERN refer to the entire pattern and looks like in your case part of the record has been standardized and part of it has been identified like "add...