DSXchange

DSScholar, For Uncert match type param1 will be expecting the cutoff threshold, which is a number between 0 and 900 Normally you used below values: 900. The two strings are identical 850. The two strings can be safely considered to be the same 800. The two strings are probably the same 750. The two ...

Whenry6000, Test the Rule Set directly, using the Rules management windows ... Looks like that classification table has been corrupted Which Rule Set are you using? I have recently installed Datastage/QualityStage 8.0.1. I am attempting to run a Qualitystage job from the tutorial, specifically the I...

Guys, Unfortunatelly for Oracle shops, the Distributed transaction stage only support DB2, Oracle is not supported yet, even the documentation clearly mention that Oracle is supported in more than one place ........ There is a distributed transaction stage or distributed transaction support for Orac...

It's mandatory ... that's the nature of the beast ... Is it Mandatory to have an Output link from the SCD stage in the ETL job when using a SCD stage. I am using a SCD stage in my job to load the Dimension table. I don't want the output sent to a file. If I just use one link to the Dimension table a...

Sam, There is not way to do it in the job itself, because the filename path does not allow any function. I would used UPCASE function in the sequence or batch used to execute this job and set my default values in the job using only upper cases so the job don't fail if executed as stand alone .... Be...

Only type1 and type2 are supported out of the box in version 8.1 ...

mekrreddy wrote:Do any one have an idea about implementing SCD type 3 in datastage V8.1 if it supports?

My two cents: qsMatchLRFlag flag is set by cetain match types that allows you to perform left/right comparisons like D_INT . Let's say that a single house number is compared to two intervals. One interval represents the left side of the street and the other represents the right side of the street. I...

dssiddu,

For Country Rule Set the literal should be surrounded by ZQ strings. This should work: ZQUSZQ

janreddy, Check cases in StateAbbreviation_USAREA field. Compare the metadata in the standardization job that populate the sample frequency data set and the one used in your match command. The Match Reference is case sensitive Also check that the path to the Frequency Data Set in your Test Environme...

janreddy, Looks like in your match specification you are using the State Abbreviation field returned from the USAREA ruleset in a match command but while generating the frequency data set this field was not included I can see two ways of avoiding this issue: - In you match frequency stage include th...

ketfos,

Check if your xmeta (metadata repository) user's password expired

basu.ds, "MCP" convert the non printable character to dots ... it won't remove the non printable characters The non printable character should be embedded in the string .. in your sample you don't have the actual characters, you have a representation which is printable, so the function jus...

manuel.gomez, Lock details are found in XMETA.XMETALOCKINFO table, but executing the cleanup_abandoned_locks.bat script should remove any entry in that table ... and you done that .... Another posibility is that the script failed when you ran it ....the script just return to the command line and doe...

manuel.gomez, Which version of IIS are you running? 8.1? DataStage logging was changed at release 8.1 to save the logs in the operational repository- xmeta -, so local project level log files (RT_LOGxxx) are not used anymore unless you manually change the default setting to save the logs in files as...

manuel.gomez,

Did you see any open session in the Web Console realted to that job?
If any active session related to that job just try to disconnect it ....