DSXchange

Mavrick- You should be able to fit a SQL up to 2^32 = 4 294 967 296 Sometimes is just not enough. We are talking space size, not number of words used in the SQL statement, so remove all empty spaces and any cosmetic format... Finally, Talk to IBM support they should be able to provide a patch to exp...

Craig- The maximum length of a SQL statement that DataStage can handle depend on the RDBMS. The maximum that Oracle 9i can handle is up to 2^16. So that will be the maximum that DataStage will accept. For post 9i, no such limit is specified by Oracle. So this limit is now raised to 2^32. So all depe...

Rahul-
Just set all cut off values (Match, Duplicate, Clerical) with same value. Let's say 25 and all records considered no matches in any pass will be available for the next pass

Regards

DsExplorer, As a general rule you could use any Rule Set in the investigation stages, that's the main purpose you investigate and Std with the same rule set... Did you try to test the EXPCOM rule set in the Rule Set Management Windows? If not just try, if working OK that rule out any installation is...

Rahul, Having same input data you should be getting same weights every time. Are you experiencing this in the match designer or while running the job? If in the match designer then there is a known issue that can be easily fix configuring the match designer to use same config file used by the job th...

Well.. I don't know about the EXPCOM rule set, but below should help

viewtopic.php?t=89199


Regards

SettValleyConsulting, You want to use CFF stage to get this requirement done If your input records are like: type 1 + columns type 2 + columns ... .. type 5 + transaction columns type 6 + addendum columns Then don't worry about the sort order and don't worry about the common field between transactio...

Kennyapril,

There is nothing to prevent installing the package in more than one server.

Normally IBM licenses cover non-production and production environments, but you should call your provider and get all clarifications about the terms in your license and then proceed


Regards

Yes, You can set up a report:

Web Console.
Reporting -->Report templates-->Security --->View Report Templates

You should be fine with "List of Users" template

Regards

Kenyapril,

Even is possible to access the CASS reference files from all environments, I would prefer separate CASS installation for each environment. At at the minimun two non-production and production

A lot of reason to go this way .....

Suryadev, You would like to use the standardized output columns from the previos job, that should improve the results of your standardization process. Better input, better output.... Basically you should force the proper input format that the USNAME rule set is expecting to get the most of it, (last...

Mav,

This method is not just to identify those activities, you should be fine doing a global replace in the dsx file and then import the dsx file back to the project. You will save a lot of time ....

Regards

Mavrick, To find out all job activities which are set as "Run" you could export the Sequences jobs to an export file (.dsx) then do a search for ExecutionType "0" A couple of lines up you will find the Job name Name "XXXXXX_XXX" Here is how the values are mapped: Execut...

Hello Ramsubbiah,

Follow Ernie suggestions ... and please try increasing the number of messages that you are expecting to unlimited

Wait time = -1
message quantity -1
end of data message type = 9999989
Record Count = 0
End Of Wave = After
End Of Data = Yes

Regards

Well... I tend to forget the old DSSendMailTester routine

Normally, I used the DSSendMailTester routine that allow the body to be parameterized

Take a look at it and post any question that you might have


Regards